Computer ForumsComputers  

Go Back   Computer Forums > PC Technology Zone > Windows Operating Systems and Software

Reply
 
LinkBack Thread Tools Display Modes
Old 05-22-2006, 09:06 AM   #1 (permalink)
True Techie
 
Join Date: Apr 2005
Posts: 195
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   Reply With Quote
Old 05-22-2006, 03:03 PM   #2 (permalink)
Dope Tech
 
Join Date: Jan 2004
Posts: 3,589
Send a message via ICQ to office politics Send a message via AIM to office politics Send a message via Yahoo to office politics
Default

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
office politics is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 12:33 AM.


Powered by vBulletin® Version 3.7.1
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.1.0