Search results

i figured it out- IIf(Format(DatePart("h",[time]),"00") & Format(DatePart("n",[time]),"00") ...use that to make the comparisons.

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...