General discussion
March 7, 2002 at 03:43 AM
sharon_minick

Hour/minute queries in Access

by sharon_minick . Updated 24 years, 5 months ago

How do you get a query to work with AM and PM time? For instance, I need to query a city database that lists delivery times for all restaurants. If I need a list of all restaurants that deliver after 10:30 PM, I can’t bring up the ones that deliver in the AM times after midnight. I can’t get a query to work even if I change all the restaurant hours in the database to military time.

Thanks.

This discussion is locked

All Comments