Hello,
I have a Time/Date field in a query which I am trying to group by specific time intervals.
I am able to do this in Excel by making the field into "hmm" text format and then doing the comparison numerically like this
IF(A1<925,8,IF(AND(A1>925,A1<936),9.3,IF(AND(A1>955,A1<1006),10.1,IF(A1>1529,15.1,HOUR((A1/100)/24)))))
How can I do this in Access?
The result I am looking for is to group by the hour of the day except for certain times which I want to distiguish seperately:
<9:25
9:55-10:05
>15:30
Thanks for the help
Damien
I have a Time/Date field in a query which I am trying to group by specific time intervals.
I am able to do this in Excel by making the field into "hmm" text format and then doing the comparison numerically like this
IF(A1<925,8,IF(AND(A1>925,A1<936),9.3,IF(AND(A1>955,A1<1006),10.1,IF(A1>1529,15.1,HOUR((A1/100)/24)))))
How can I do this in Access?
The result I am looking for is to group by the hour of the day except for certain times which I want to distiguish seperately:
<9:25
9:55-10:05
>15:30
Thanks for the help
Damien