Help with Query when no data for a col.

[Pvarga]

I have a DB that contains statistics on students in a program. There are 5 age groups.
When I run my query for my end of year results and only have students in one or two age groups of course that is all that shows up in the query. The only problem is my report that is based on this query will look for all 5 age groups . I have it set that way so I can give it to different sites at the beginning of the year and it is set up for them. It needs to be uniform for all sites and I will never know which will use all 5 age groups. How can I make all 5 show up even if they show zeros.

Thanks much

Tricia

 

[Pat Hartman]

I presume that the query is a crosstab and it is the missing columns that are causing the problem.

You can force a crosstab to return a column for each possible value by listing them all in the ColumnHeadings property. The columns for which there was no data in the selected recordset will be null. Look up the ColumnHeadings property in help.

 

[Pvarga]

Thank you I think that will work. I just looked quickly looked afterward but I seem to be getting a wierd box when I run my report off this query. It is showing my first field and asking for the parameter.

I need to look this up also. I do not know what that means.