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.