Find the maximum time vs the target time

[AccessNewby]

I have the following columns in a query. I want to create another query using the data from this original query. My goal is to find the latest time for each endpoint for each company. There are two deadlines..a 9:30 AM and a 9:50 AM so any time after 9:50 would be considered "Late", any time after 9:30 would be considered "Last", all others are "Prior".
So far this is what I have, I added a column for an Expr1 to extract the time by using the MID function but when I tried to add another Expr for the target time it would not accept the 9:30 AM. Could anyone give me an advice/suggestion on how to go about this??

A. 10/14/2008 3:39:35 AM
B. Company Name
C. End points (there are 2-4 endpoints for each company and each endpoints can have multiple delivery times)

Please explain it in layman's terms since I am very new to Access.
Thank you in Advance

 

[Brianwarnock]

Date and time are stored as a decimal number. The value before the decimal translates into the date and the value after the time. To extract the time only use Timevalue(yourfield).

Your query will be a totals query and group on Company and endpoint and use max for time.

Brian

 

[AccessNewby]

Thank you for your suggestion. It took me forever to understand what you were saying but I got it now. thanks.

 

[Brianwarnock]

Sorry if my resply was less than clear, still thinking is good for the brain and certainly struggling helps you to remember.

Brian