Crosstab Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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]))
 
Back
Top