Hey I need to make a table in Access to take weekly inputs (with hours) and count the number of occurences at half an hour intervals.
I've separated the date and time fields so I group by date and group by hour using this formula: "Hour_: DatePart("h",[Time(fraction)])"
Problem is I need to get half an hour precision.

I'd be glad if anyone knows how to do this (either by datepart or not)

Thanks in advance
Elad

Hi Elad,

If you wanted the value to be displayed on a scale of 0 to 48 then you can use this

HalfHour_: (DatePart("h",[Time])*2)+Int(DatePart("n",[Time])/30)

So if the time value is say 05:15 am then the result would be displayed as 10. If the time value was 05:35 am then the result would be 11. Basiccally you have split the day into 48 slots instead of 24.

HTH

Jon

Dear Jon
Thank you very much from your help
worked like a charm

Elad