Crosstab Queries not acting the same

[talia679]

I have two crosstab queries that do the same exact thing for two different queries, but they aren't appearing the same.

View the attached image to see how they are set up.

When I view the top one I see all of the months from jan - dec even though there is no data for the future months.

When I view the bottom one it only shows me April - Sept which are the months it has data for.

I want them both to show all months - whether there is data or not.

Any ideas? These aren't the only 2 queries I have that do this ... so any and all suggestions are welcome.

 

[Sohaila Taravati]

If you set up your Column Headings in the cross tab, it will show you all the months weather there is data or not!

 

[talia679]

The date is the column heading and it's not showing the info ... if there's more i need to do to "set it up" then I need to know how to do that ... All i know is to set the crosstab to column heading ... which it is as you can see by the image.

 

[Sohaila Taravati]

Go to the design of your crosstab query and right click in the gray area and look at the properties of your query. The second option is Column Headings. That is where you want to set them up. you can go to help and find out about the column headings in crosstab too.