Query too Complex

[Jim]

On one pc I receive a message "Query Too Complex" On a
2nd with a duplicate copy of the same database, no
problem. Is there a setting I need to adjust on the 1st
pc? Deleting one calculated field eliminates the problem
but kills the purpose of the query.

 

[Allen Browne]

Try explicitly typecasting your calculated field. The error message can
indicate that the data type does not look correct, and so Access can't
parse.

More info:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

 

[Tony]

Compair the module references in both database.

Tony