问题描述
我有一个真正简单的交叉表查询，我试图总结为
操作，但我得到的是数据类型不匹配条件表达式
错误。从这个交叉表中关于食物链的三个查询
查询我使用的是一个简单的查询，没有分组我在过滤
标准行中的一些数据。
我已经无法使用几年了但是我记得在
过去我有一个解决方案，但我不记得了。非常感谢您对这个
的任何帮助。
谢谢
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
推荐答案
感谢您的帮助。我查看了你的页面并对我的查询进行了一些更改
，但我仍然得到同样的错误。下面是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
感谢您的帮助。我查看了你的页面并对我的查询进行了一些更改
，但我仍然得到同样的错误。下面是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.
这篇关于交叉表查询数据类型错误标准表达式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！