交叉表查询数据类型错误标准表达式 [英] Cross tab query data type mispatch criteria expression

问题描述

我有一个真正简单的交叉表查询，我试图总结为

操作，但我得到的是数据类型不匹配条件表达式

错误。从这个交叉表中关于食物链的三个查询

查询我使用的是一个简单的查询，没有分组我在过滤

标准行中的一些数据。


我已经无法使用几年了但是我记得在

过去我有一个解决方案，但我不记得了。非常感谢您对这个

的任何帮助。


谢谢

I have a real simple cross-tab query that I am trying to sum on as the
action but I am getting the "data type mismatch criteria expression"
error. About three queries up the food chain from this cross-tab
query I am using a simple query with no grouping where I am filtering
some data out in the criteria line.

I have been out of access for a couple years but I remember in the
past I had a solution for this but I can''t remember. Any help on this
is much appreciated.

Thanks

推荐答案

对于查询中的计算字段（特别是那些涉及Nz（）），Access

可能会对数据类型感到困惑。解决方案是明确

类型表达式。


详情请参阅：

计算字段曲解错误

at：
http://allenbrowne.com/ser-45.html


-

Allen Browne - 微软MVP。西澳大利亚珀斯

访问用户提示 - http：// allenbrowne .com / tips.html

回复群组，而不是mvps dot org的allenbrowne。


" aaronrm" < aa ***** @ gmail.com写信息

news：11 ********************** @ k78g2000cwa。 googlegr oups.com ...

For calculated fields in a query (particularly those involving Nz()), Access
is likely to get confused about the data type. The solution is to explicitly
typecast the expressions.

Details in:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"aaronrm" <aa*****@gmail.comwrote in message
news:11**********************@k78g2000cwa.googlegr oups.com...

>我有一个真正简单的交叉表查询，我试图总结为

动作但是我得到了数据类型不匹配标准表达式

错误。从这个交叉表中关于食物链的三个查询

查询我使用的是一个简单的查询，没有分组我在过滤

标准行中的一些数据。


我已经无法使用几年了但是我记得在

过去我有一个解决方案，但我不记得了。对此

的任何帮助都非常感谢。

>I have a real simple cross-tab query that I am trying to sum on as the
action but I am getting the "data type mismatch criteria expression"
error. About three queries up the food chain from this cross-tab
query I am using a simple query with no grouping where I am filtering
some data out in the criteria line.

I have been out of access for a couple years but I remember in the
past I had a solution for this but I can''t remember. Any help on this
is much appreciated.

2月11日下午4:49，Allen Browne < AllenBro ... @ SeeSig.Invalidwrote：

On Feb 11, 4:49 pm, "Allen Browne" <[e-mail]:

对于查询中的计算字段（特别是那些涉及Nz（）），Access

可能会对数据类型感到困惑。解决方案是明确

类型表达式。


详情请参阅：

计算字段曲解错误

at：
http://allenbrowne.com/ser-45.html


-

Allen Browne - 微软MVP。西澳大利亚珀斯

访问用户提示-http：//allenbrowne.com/tips.html

回复群组，而不是mvps dot org的allenbrowne。


" aaronrm" < aaro ... @ gmail.com写信息


新闻：11 ********************** @ k78g2000cwa.googlegr oups.com ...

For calculated fields in a query (particularly those involving Nz()), Access
is likely to get confused about the data type. The solution is to explicitly
typecast the expressions.

Details in:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"aaronrm" <[e-mail] in message

news:11**********************@k78g2000cwa.googlegr oups.com...

我有一个真正简单的交叉表查询，我试图总结为

动作但是我得到了数据类型不匹配标准表达式

错误。从这个交叉表中关于食物链的三个查询

查询我使用的是一个简单的查询，没有分组我在过滤

标准行中的一些数据。

I have a real simple cross-tab query that I am trying to sum on as the
action but I am getting the "data type mismatch criteria expression"
error. About three queries up the food chain from this cross-tab
query I am using a simple query with no grouping where I am filtering
some data out in the criteria line.

我已经无法访问几年但我记得在

过去我有一个解决方案但我不记得了。对此我的任何帮助

非常感谢。

I have been out of access for a couple years but I remember in the
past I had a solution for this but I can''t remember. Any help on thisI
is much appreciated.

感谢您的帮助。我查看了你的页面并对我的查询进行了一些更改

，但我仍然得到同样的错误。下面是calc

字符串。


LoanAmount2：CCur（nz（[emdbuser_LoanSummary]！[LoanAmount]））


我尝试通过在这个字段中运行一个简单的选择查询进行简化

在一个新查询中我可以得到相同的错误。在您的网站上显示，

表示Access无法将

字段识别为数字。


谢谢

Thanks for the help. I took a look at your page and made some changes
to my query but I am still getting the same error. Below is the calc
string.

LoanAmount2: CCur(nz([emdbuser_LoanSummary]![LoanAmount]))

I tried simplifying by running a simple select query off of this field
in a new query and I can getting the same error. It appears as is
stated on your website that Access is having problems recognizing the
field as a number.

Thanks

您是否尝试指定一个用于null的值？


它是Nz的第二个参数（）：

LoanAmount2：CCur（nz（[emdbuser_LoanSummary]！[LoanAmount]，0））


-

Allen Browne - 微软MVP。西澳大利亚珀斯

访问用户提示 - http：// allenbrowne .com / tips.html

回复群组，而不是mvps dot org的allenbrowne。


" aaronrm" < aa ***** @ gmail.com写信息

新闻：11 ********************** @ a34g2000cwb。 googlegr oups.com ...

Did you try specifying a value to use for null?

It''s the 2nd argument of Nz():
LoanAmount2: CCur(nz([emdbuser_LoanSummary]![LoanAmount], 0))

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"aaronrm" <aa*****@gmail.comwrote in message
news:11**********************@a34g2000cwb.googlegr oups.com...

2月11日下午4:49，Allen Browne < AllenBro ... @ SeeSig.Invalidwrote：

On Feb 11, 4:49 pm, "Allen Browne" <[e-mail]:

>对于查询中的计算字段（特别是涉及Nz（）的字段），
Access
可能会对数据类型感到困惑。解决方案是明确地说明表达方式。

详细信息：
计算字段被误解为
http://allenbrowne.com/ser-45.html

" aaronrm" < aaro ... @ gmail.com写信息

新闻：11 ********************** @ k78g2000cwa.googleg roups .com ...

>For calculated fields in a query (particularly those involving Nz()),
Access
is likely to get confused about the data type. The solution is to
explicitly
typecast the expressions.

Details in:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

"aaronrm" <[e-mail] in message

news:11**********************@k78g2000cwa.googleg roups.com...

>我有一个真正简单的交叉表查询，我试图总结为

操作但是我得到了数据类型不匹配标准表达式

错误。从这个交叉表中关于食物链的三个查询

查询我使用的是一个简单的查询，没有分组我在过滤

标准行中的一些数据。

>I have a real simple cross-tab query that I am trying to sum on as the
action but I am getting the "data type mismatch criteria expression"
error. About three queries up the food chain from this cross-tab
query I am using a simple query with no grouping where I am filtering
some data out in the criteria line.

我已经无法访问几年但我记得在

过去我有一个解决方案但我不记得了。对此我的任何帮助

非常感谢。

I have been out of access for a couple years but I remember in the
past I had a solution for this but I can''t remember. Any help on thisI
is much appreciated.

感谢您的帮助。我查看了你的页面并对我的查询进行了一些更改

，但我仍然得到同样的错误。下面是calc

字符串。


LoanAmount2：CCur（nz（[emdbuser_LoanSummary]！[LoanAmount]））


我尝试通过在这个字段中运行一个简单的选择查询进行简化

在一个新查询中我可以得到相同的错误。在您的网站上显示，

表示Access无法将

字段识别为数字。

Thanks for the help. I took a look at your page and made some changes
to my query but I am still getting the same error. Below is the calc
string.

LoanAmount2: CCur(nz([emdbuser_LoanSummary]![LoanAmount]))

I tried simplifying by running a simple select query off of this field
in a new query and I can getting the same error. It appears as is
stated on your website that Access is having problems recognizing the
field as a number.

这篇关于交叉表查询数据类型错误标准表达式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！