Mar 11 2005, 12:07 PM
I have a crosstab report with Requirements (Rows) and Divisions (Columns). The database deals with contracts for each division and what requirements each contract has.
I created "test" data entries for each division so that i could create the crosstab query for the report. In reality though, it is likely that not every division will have a contract ie: Corporate. If i delete the corporate "test" record from the DB I get an error message that says "Microsoft Jet database engine does not recognize 'Corporate' as a valid field name or expression."
My question is - I don't want to have to add or take away a new field each time i wish to create a report. Is there a way to make that happen?
Thanks for the help
Mar 11 2005, 12:15 PM
If I understand you problem correctly this may help.
Open your query in design grid view. Right click in the grey background area & select properties. Under the Column Headings property you can force the query to use the set of Column Heading you want.
For example use: -
to force all months to be included even where no data is found for a particular month.
Mar 11 2005, 12:19 PM
Thanks a lot! That works great.
Mar 11 2005, 12:21 PM
By any chance...you wouldn't happen to know how to get rid of the box around check box's? It's for a report and it looks messy with the box's.