Report grouping

[dpw]

I'm experiencing difficulties sorting a field with a date/time value. The value for midnight falls on the previous day's grouping.

Any ideas are welcomed

 

[pdx_man]

Base the report on a query where you add 1 second to the field. When you get to the report, subtract one second.

Query-
NewDate: dateadd("s",1,[OrigDate])

Report-
Control Source =dateadd("s",-1,[NewDate])

HTH