=========
QUESTION
———
All I am doing is trying to do a calculation or manipulation on a field in my query, and it comes up with #Error rather than the results.

If I do the calculation in a test field, it works just fine – what’s going on?

 

=========
ANSWER
———
Obviously, this could be a thousand different things – but DOUBLE-CHECK your query fields.

Is it possible you are using a field name from some other place in your criteria where you are already doing a calculation, instead of what you think you are doing: getting it from the table itself?
This will cause that error every time!

Change all your field names in your calculation to absolute references:
[TableName].[FieldName]
instead of just
[FieldName]

 

=========
EXAMPLES
———

 

=========
APPLIES TO / KEY WORDS
———
Microsoft Access
Error
#Error

 

=========
REF
———

 


http://anySiteSupport.com
http://anySiteHosting.com