Computers |
|
| | #1 (permalink) |
| True Techie Join Date: Apr 2005
Posts: 195
| 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. |
| | |
| | #2 (permalink) |
| Dope Tech | this shoudl point you in the right direction Extract a part of a date or time value http://office.microsoft.com/en-us/as...984871033.aspx Using dates and times in Access http://office.microsoft.com/en-us/as...21033.aspx#b50
__________________ Tech IMO.com | ExtremeTech.com | ASP Free.com | SysOpt.com | Tech Support Guy.org DB Forums.com | Cyber Tech Help.com | Lazy Forums.com | Warrior Nation.net 'If you don't stand for somethin you'll fall for anything' - Dr. Dre Been there, done that |
| | |