访问消息太复杂了 [英] Access msg Too complex

问题描述

嗨大家好，


以下SQL语句有效

展开 | 选择 | Wrap | 行号

解决方案

嗨大家好，


以下SQL语句有效

展开 | 选择 | Wrap | 行号

Hi FishVal，


仍然会出现同样的错误，不要不知道是什么导致这个，但我知道它与这个日期字段的比较（真的希望原始设计师在记录中包括日期字段而不是仅仅周和年）



无论如何，谢谢


会不断尝试.....

Hi FishVal，


仍然得到同样的错误，不知道是什么导致了这个，但我知道它与这个日期字段的比较有关（真的希望原设计师把日期字段包含在记录中，而不仅仅是周和年）



非常感谢


将继续尝试.....


确定。


将条件字段移动到查询的SELECT子句，以查看它们是否被正确检索。

Hi folks,

The following SQL statment works

Expand|Select|Wrap|Line Numbers

解决方案

Hi folks,

The following SQL statment works

Expand|Select|Wrap|Line Numbers

Hi FishVal,

still getting the same error, don''t know what''s causing this but I know its to do with the comparison on this date field (really wish the original designer had included the date field on the record instead of just the Week and Year)


Thanks anyway

Will keep trying.....

Hi FishVal,

still getting the same error, don''t know what''s causing this but I know its to do with the comparison on this date field (really wish the original designer had included the date field on the record instead of just the Week and Year)


Thanks anyway

Will keep trying.....

Ok.

Move criteria fields to SELECT clause of the query to see whether they are being retrieved correctly.

这篇关于访问消息太复杂了的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！