Error Message 3169

[krispi]

One of my reports is refusing to open. Instead, it throws up an error 3169: "The Microsoft Jest database engine could not execute the SQL statement because it contains a field name that has an invalid data type."

The query my report is based on works fine. That being the case, I can't work out which SQL statement the error message is referring to so I've got no chance of trapping the error.

When I created this report it worked fine.

Any ideas/suggestions would be gratefully received.

Thanks
Chris

 

[CosmoKramer]

From Access help:

Possible causes:

·	You included a Memo or OLE Object field in an expression where it isn't allowed.
·	You included a numeric aggregate function, such as Sum or StDev, that tried to perform a calculation on a Text field. Choose a different aggregate function.