First and Last timestamp for each day

Topic

New Reply

I have an database used in a small bookstore for sales/inventory. Punctuality was an issue, so I created a table that would time stamp when the database was opened and closed.

I have a table that has 2 columns, both are Date/Time fields like “9/18/2009 5:15:49 PM” where one is named “Started” and one is named “Ended”. If a row has a Started, it will have no Ended and vice versa.

I need to have a query that shows the earliest Started and the latest Ended for each day. (Did they arrive on time and did they leave early?)

Any suggestions?

Thanks!

Reply | Quote

Replies

Create two queries. One to calculate the Min Start time by date and the other to calculate the Max End time by date. Link the two queries by date. See attached (qryMinMax shows the final results):

Reply | Quote

Create two queries. One to calculate the Min Start time by date and the other to calculate the Max End time by date. Link the two queries by date. See attached (qryMinMax shows the final results):

This worked like a charm, thanks!

Reply | Quote