Order by Date and Time - Does not work properly.

  • Thread starter Thread starter Stewart Saathoff
  • Start date Start date
S

Stewart Saathoff

Hello Everyone,

I have an access report that has four date and time fields on it.

InDate
InTime
OutDate
OutTime

When I try to order the report by date and time, it works except when the
time is between 12:00 PM and 12:59 PM. (Lunch time)

If someone fills in a time of 5:00 PM, the report will display the 5:00 PM
time prior to the 12:00 PM time.

I imagine it is doing this because 5 is a smaller number than 12. Does
anyone have any ideas on how to resolve this?
 
first in the table design make sure that the time fields
have a datatype as Date/Time. Then in the format for these
fields select Medium or Long Time. This should correct
the sorting problem.
 
I used this format for the report:

m/d/yyyy h:nn:AM/PM

because I did not want the seconds to be displayed. It's not necessary...
 
Don't apply any format to the data in your query. Just put the field in your
report as is and set the sorting and grouping to the field. You can then
format your data in the text box however you want it to appear.
 
Back
Top