Access error

[bradwc]

I Have an Access 97 DB that I added some new reports to. And every thing worked fine last month, but now I am getting the following error on all of my queries.
"This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."

I know for a fact that nothing has changed in this DB. So it is puzzling me how all of the sudden I am getting this error. I have gone back to an old backup that was dated the day I created the reports. It still gives me these errors and I know it was working on that day. It’s a mystery. I was told that access does that some times, just stops working. Has anyone else had this issue? I appreciate any help you can give me.

 

[araskas]

I undersatnd that the only thing that changed between the time you created the query and now is data. I bet there are some fields in your table or data source for your query that have null values in some of the fields ( numeric or text or both) where as your query is not expecting nulls to be in it. Clean your data by first sorting on each column in ascending order and see if there are any null values or may be text in numeric fields etc.