My database buttons no longer work

[mcmcd99]

Oh I see what it did. It doesn't actually store the time as a 24 hour clock. Was hoping it would store it like that so that they could easily edit it without having to erase all that extra stuff. Replacing 15:10 with 15:15 if need, instead of replacing 13:10:21 PM with 15:15 you know.

[davegri]

Open the tbl_AirTrafficLog in design view and set the property of tstime to short time.

[mcmcd99]

Take two steps forward and one step back. Now my reports aren't sorting by date and time correctly
I'm sorry to keep bothering you, but any suggestions?

[mcmcd99]

sorting by tstime on the single date report is an easy fix, since it's only one day at a time. But on the month or complete ones, I'm not sure how to sort by both date and time so that it appears linear. I've tried [tsdate],[tstime] but that didnt' seem to do the trick.

[June7]

Set the sort criteria in report design, not in query. The rpt_date and rpt_month already have sort criteria for tsdate. I added a sort for tstime and it works.

[mcmcd99]

That did it. You're the best.

[ArviLaanemets]

In your table tbl_AirTrafficLog you have 2 fields - Date and Time (a bad choice of field names, btw.). They both are really datetime fields, and contain same date and time, but are formatted differently.

There is no reason to keep 2 different fields with same information. Scrap the one, and format remaining (name it something like FlightTime or whatever you like more) one as datetime, p.e. as "mm/dd/yyyy hh:mm".
In form for air Traffic Log leave also a single field.
In reports either use textbox with this datetime field as source, formatted in same way as in table, or hide it and use 2 unbound forms with source as

= INT([FlightTime])>

formatted as date ("mm/dd/yyyy"), and

= FlightTime - INT(FlightTime)

formatted as time ("hh:mm").

For any filter conditions also use

INT(FlightTime) = YourConditionDate