Crosstab Query

D

David

Hello,

I have a crosstab query that has dates going across and times going down.

Is their a way to group the time going down into 2hr intervals or even 1 hr
intervals.

Any help would be great
Thank You
Dave
 
A

Allen Browne

Presumably the times are coming from a date/time field, and this field is a
Row Heading in your query.

If so, you could try using one of these expressions as your Row Heading:
DatePart("h", [MyField])

DatePart("h", [MyField]) \ 2

Int(12 * TimeValue([MyField]))
 
Top