View Single Post
Old 05-22-2006, 10:06 AM   #1 (permalink)
Seiken
 
True Techie

Join Date: Apr 2005

Posts: 193

Seiken

Default Microsoft Access Help Needed: Query using Date & Time

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.
Attached Images
 
Seiken is offline