问题描述
大家好，
我已经遇到了另一个绊脚石的令人沮丧的沮丧。
请附上我的项目的精简版本，其中包含报告，子表格以及他们所依赖的表格和查询。
开运行报告我收到错误消息：
"这个表达式键入不正确，或者它太复杂而无法评估。例如，数字表达式可能包含太多复杂元素。尝试通过将表达式的一部分分配给变量来简化表达式。
对于tblOrderDetails中的每条记录，消息都会出现一次（表格被裁剪以防止数百个）。其中一个查询包含计算字段，我尝试将这些表达式作为子表单上的计算控件输入，结果相同。
我已检查链接字段的格式。
我的睡眠剥夺了大脑的伤害。建立此发票是它上线之前的最后一个障碍。任何指针都会受到赞赏。
Jay
Hi Guys,
I''ve hit another frustrating braintwister of a stumbling block.
Please find attached a stripped down version of my project containing a report, a subform and the tables and queries they depend on.
On running the report I get the error message:
"This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numberic expression may contain too many complicated elements. Try Simplifying the expression by assigning parts of the expression to variables."
The message appears once for each record in tblOrderDetails (tables cropped to prevent hundreds). One of the queries contains calculated fields, I have tried entering these expressions as calculated controls on the sub-form with the same result.
I have checked the formatting of the linked fields.
My sleep deprived brain hurts. Building this invoice is the last hurdle before go it goes live. Any pointers would be appreciated.
Jay
推荐答案
这篇关于“表达式键入不正确或太复杂”。在报告子表单上。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！