Images within a report Data Mismatch

[Brenwin]

I want to display data from a query that includes images.

I've stored the complete path and filename to the actual files themselves within a table, and then I use the Image tool to update the display via some simple code.

I get a Error 13 Data Mismatch message, when doing this when the query removes all Is Null date values.

Without this parameter, everything works, but then I get a report with a bunch of data I don't need (i.e. with null dates).

Can anyone help? - Many thanks

 

[traingamer]

Can you post the query that is giving you the error?

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[Brenwin]

Many thanks for replying, but I think I sorted it (got around it) yesterday.

The problem arose because I had an empty field - once I filled in the field, problem gone.

My apologies for not posting this sooner.

Thanks again!