Printing columns depending on date range

[marathonlady]

I have a report that prints where the user gets to enter a start date and an end date, but the end date can be up to 31 days beyond the start date. So the most info printed will be 31 days of totals. If they only ask for 10 days, I don't want the other 21 days to print (they are printing as zeros now, but I want blanks
in there place, along with the date label so it's obvious that only 10 days were asked for. How do I suppress the days I don't want.

Thanks in advance for any help.

 

[Rich]

Do you have 31 fields, or 31 totals records with each date as a separate record?
A cross tab will handle the second

 

[marathonlady]

Reply to Rich

The query that my report runs off has 31 columns, Day1, Day2
(I use DateAdd to determine Day2-Day???). If the user requests
from 5/1/2002 to 5/10/2002, then from 5/11/2002 thru 5/31/2002 has zeros in them, I don't put the totals in the query. So the report has a field for each day then. So on the report, Day11 thru Day 31 I want suppressed, in this instance.