Reports from crosstab query

[duvenhlc]

Hi All out there,

I discoverd a problem with my reports that is running off a cross tab query. It is working fine, until I covert the database to 2007 format. I then get a "type misatch" error. I have downloaded some of the samples off the forum, and they also do it.

Do I miss something?

Regards

Lance

 

[ajetrumpet]

pretty vague description sir.

 

[duvenhlc]

What is vague, please look at the database attached, it is not mine. I use the similar code. Open the report no problem. Convert the db to 2007 format, open the report again.

You will get an error, "Type mismatch"

Lance