Microsoft Access Help Needed: Query using Date & Time

[Seiken]

I'm trying to query records based on date and time. We have a database that we print receipts off based on the date we received these records. The end-users of this database have requested that we add a time function to these receipts so that when they print receipts, they are not wasting paper with duplicate receipts that have been printed earlier that day.

Right now, the query prompts the user to enter a "From Date" and a "To Date." What can I add in query so that in the "From Date" also asks for time in military format (or regular, doesn't matter).

Any help is appreciated.

 

[office politics]

this shoudl point you in the right direction

Extract a part of a date or time value

http://office.microsoft.com/en-us/assistance/HP010984871033.aspx

Using dates and times in Access

http://office.microsoft.com/en-us/assistance/HA010546621033.aspx#b50