Crosstab report - handling Null fields

G

Guest

I've got a report based on a crosstab query reporting monthly data. The
problem is, if I have not put in any data for one of the months, I get an
error "The Microsoft Jet database engine does not recognize " as a valid
field name or expression."

Any ideas on how to handle this?
 
G

Guest

You can enter all possible months into the Column Headings property of the
crosstab query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab report - handling Null fields 4
Wizard crosstab report failure 1
Report Error for certain Crosstab Query 2
Report based on filtered crosstab 5
Access Does not recognize " as a valid field name or expression 1
Problem with crosstab report 4
Setting Date Range on a crosstab 3
crosstab query with parameter query 5

Top