Displaying Column Headings with no values in a Crosstab Qry 2

[starlitskies]

I am running a crosstab query and I'd like the column headings to be displayed even when there are no values in that column. (Ultimately, I'd like to project all the data into a report.) Is there some way to do this?

Thank you kindly.

 

[jsteph]

Use the IN() clause at the end of the statment.
--Jim

 

[dhookom]

To add to what Jim suggests, you can build the "IN()" clause by entering possible column names in the Column Headings property of the crosstab.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]