Totals Query for Report

[SpdRacerX]

I'm trying to create a report that counts time records per month. I've created multiple queries that counts the records within certain time frames (which I will combine into a Union query...which is the only way I can figure out how to do it, which I will then use for the report).

My question is how would I word multiple criteria in the queries.

<6 Hours
>6<24 Hours
>24<48 Hours


>48 Hours

The ones with one criteria I figured out but not the ones with multiple criteria.

[Robeen]

From what you say, it seems like you are able to get the records with less than 6 hours [using < 6 - right?
For 6 hours to 23 hours try:
> 5 AND < 24
For 25 to 47:
>24 AND < 48

Let me know if that's what you need.

[SpdRacerX]

Exactly what I needed thanks.

[Robeen]

You're welcome. Happy I could help!