MS Access Database engine does not recognize " as a valid field name or expression?

[diofree]

MS Access Database engine does not recognize " as a valid field name or expression?

Hi guys,
I have a report, pulling off a crosstab query that works fine for awhile, and then stops working and throws this error:

"the microsoft access database does not recognize " as a valid field name or expression".

I have a combobox, which a user selects, which sends a parameter to a crosstab query. The crossstab query works fine, but after awhile, the report I have connected to it just stops working and gives me that error.

Any ideas?

 

[plog]

Re: MS Access Database engine does not recognize " as a valid field name or expressio

This is why reports based off crosstabs are a bad idea. I believe you have a Null value in the field you are converting to column headings in the cross tab. Open your crosstab query by itself and look at the first column to verify this. The first column should have no name appearing atop it.

For example suppose you had this regular query:

qrySales
SalesMonth, TotalSales
, 55
April, 122
August, 541
December, 132
...

If you tried to make that a cross tab and turn the SalesMonth into columns you would get a first column with the name "". Then when you go to make a report on it, it has no idea what you are talking about.