Microsoft Access Help Needed: Query using Date & Time - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 05-22-2006, 10:06 AM   #1 (permalink)
True Techie
 
Join Date: Apr 2005
Posts: 188
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
File Type: jpg query.jpg (23.2 KB, 33 views)
__________________

Seiken is offline  
Old 05-22-2006, 04:03 PM   #2 (permalink)
It's all just 1s and 0s
 
office politics's Avatar
 
Join Date: Jan 2004
Location: in the lab
Posts: 6,555
Send a message via MSN 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
office politics is offline  
Closed Thread

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 Off




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 09:27 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.