Data type mismatch

[branston]

I have a report with a lot of fields, which is based on a query. The query runs fine but when I try and run the report I get an error:
"Data type mismatch in criteria expression"

Any idea how I can narrow this down to a certain field? I can't see anything obvious and I have a very similar query/report which runs fine!

Thank you!

 

[Uncle Gizmo]

I would suggest using and the report wizard to recreate a new report based on the selfsame query, then have a look at these two reports the one that doesn’t work and the one that does, see if there are any obvious differences.

 

[branston]

Ah good thinking. Thanks!

 

[vbaInet]

Since you're getting the error on the report I suspect it to be code you have in the report module. You will normally get a mismatch when assigning a value or performing a comparison.

If this is the case, what line does it highlight when you hit Debug?