Goup by minutes in a pivot chart

[poring]

Hello,

I'm trying a build a pivot chart based on my data and I'm having an issue
when grouping by minute.

I have a "time" column which has the format hh:mm:ss and I would like to set
it to the bottom axis and group by minute. I actually can get this far,
except that Access does not take the hours into account. For example, if I
have a record for which the time is 15:18:25 and another one for which the
time is 16:18:55, these two records are grouped because they have the same
minute, which is of course not what I want!


Can anybody help? Thanks

 

[Allen Browne]

Try typing an expression like this into the Field Row:
MinuteOfDay: DateDiff("n", #00:00:00#, [YourTimeFieldNameHere])

This gives the number of whole minutes since midnight, which should work for
your chart.

If the field contains a time as well as a date, use:
TimeValue([YourTimeFieldNameHere])
rather than just the field name.