I have a database for tracking productivity. Everytime that a product is scanned a date is entered and a time is entered. I need to calculate how many products are scanned between the date1 7am and the date2 6:59:59. We have a 7am to 7am workday. Can anyone help?

You should probably be using a parameter query to make this work.

You can find some nice example about this on

http://www.fontstuff.com/access/acctut08.htm

and change some of the parameters in the query according to what you need...