Crosstab jet database engine problem

[scottian]

Ive created a crosstab query in a database, the database got too big so i decided to import all the objects into a new shell, but now a crosstab query has just decided to stop working. it works fine in the original database but not in the new one. i get an error
"the jet database engine does recognise <> as a valid field name or expression". i cant see anything wrong but im stumped. Can anyone help, please.

"Children are smarter than any of us. Know how I know that? I don't know one child with a full time job and children."...Bill Hicks

 

[Remou]

Have you checked that your code compiles?

 

[Golom]

And also check your references. The new database may have defaulted to DAO 3.51 rather than DAO 3.6

 

[dhookom]

It could be the result of different records in the databases. Do you have any Nulls in the field you are using for the Column Headings?

Duane
Hook'D on Access
MS Access MVP