How do I remove empty rows from a crosstab query/report?

[psearcy]

I have an Access report that is based on a crosstab query. The row headings are descriptions and the column headings are months stored as text (i.e. JAN, FEB, etc.)

In the query I have specified the months that I want to view by specifing the column headings in the field properties dialog box, but this method includes empty rows in the query and report. For instance, I am looking at data from JUN, JUL, and AUG and in some cases there is no data for these months, but since there is data in previous months the query returns empty rows.

Any advice will be greatly appreciated.

 

[dhookom]

You should be able to create a column (row heading) that sums just your date range. You can then filter on this sum. If you can't figure this out, come back with your SQL view as well as how you are setting the date range.

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]