Combining queries in a report.

[Misty]

I have a table that contains work order numbers and the dates that the work orders were written.

I need to create a report that shows this information seperated by these groupings:

0-15 days old
16-30 days old
31-45 days old
45 days and older

Can someone give me an idea as how to make a report like this happen?

TIA
M

 

[namliam]

I usually create a table

LowerValue UpperValue Text

Then use that in an unjoined query having a where clause:
Where ([Value] <= uppervalue and [Value] >= Lowervalue)
or ([Value]>=Lowervalue and [uppervalue] is null)

Or something simular

 

[mwn1218]

You could create a queires that sort the data into those categories then use each query as a sub report.

 

[Misty]

Sub-reports. I keep forgetting to use them.

Thanks guys. I'm a little brain dead anymore.

M