Hello all,

I am having difficulties with a crosstab query. I need to have row headings show for each possible row type - Even if there is no data to display. I have bulit a table with the row headings I need and created a relationship to the table with my data. I have specified in the Query Window to show all records in my row headings table.

It is still not working.

I would appreciate any help as I am under a deadline.

Thank you,
Doug

post your query and I will be able to help

Click on the column field in the query's design view, go to Properties.
Under column headings type all the names you need in the order you need them to display e.g. "aaa","bbb","ccc" etc. Each one needs to have the " " around it, with a comma between each entry. When you run it, the query will return all the column names you listed even if the cells are empty.
Good luck