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
-B

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: -

"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"

to force all months to be included even where no data is found for a particular month.

Thanks a lot! That works great.

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.

Thanks (IMG:http://www.utteraccess.com/forum/style_emoticons/default/frown.gif)