Crosstab report - handling Null fields

J

Jason

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?
 
D

Duane Hookom

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
Report Error for certain Crosstab Query 2
Report based on filtered crosstab 5
Wizard crosstab report failure 1
Access Does not recognize " as a valid field name or expression 3
Trying to create a report that will list unmatched records by Ticket Primary Key 0
crosstab query with parameter query 5
getting a report from a crosstab query 28

Top