Page 1 of 1 1
Topic Options
#153473 - 2005-12-15 01:01 PM MS ACCESS date query
Stephen Wintle Offline
Seasoned Scripter

Registered: 2001-04-10
Posts: 444
Loc: England
Hi,

Using a select query in MSaccess I want my users to run my query which prompts them for a date 'dd/mm/yyyy' and then displays records from the table just for the date they have entered I tried just adding [Enter date] in my query but it dosent return any records...

Thanks

Steve
_________________________
Dont worry because a rival imitates you. As long as they follow in your tracks they cant pass you!

Top
#153474 - 2005-12-15 11:41 PM Re: MS ACCESS date query
Kdyer Offline
KiX Supporter
*****

Registered: 2001-01-03
Posts: 6241
Loc: Tigard, OR
Can you show us the SELECT Statement?

You may want to go to http://utteraccess.com , http://mvps.org/access , or http://candace-tripp.com for some great examples using dates.

Kent
_________________________
Utilize these resources:
UDFs (Full List)
KiXtart FAQ & How to's

Top
#153475 - 2005-12-16 04:26 AM Re: MS ACCESS date query
Sealeopard Offline
KiX Master
*****

Registered: 2001-04-25
Posts: 11165
Loc: Boston, MA, USA
From where do you run the query? From within a script or directly in MS Access?
_________________________
There are two types of vessels, submarines and targets.

Top
Page 1 of 1 1


Moderator:  Arend_, Allen, Jochen, Radimus, Glenn Barnas, ShaneEP, Ruud van Velsen, Mart 
Hop to:
Shout Box

Who's Online
0 registered and 764 anonymous users online.
Newest Members
ManuvdWielNL, Sir_Barrington, batdk82, StuTheCoder, M_Moore
17887 Registered Users

Generated in 0.095 seconds in which 0.068 seconds were spent on a total of 12 queries. Zlib compression enabled.

Search the board with:
superb Board Search
or try with google:
Google
Web kixtart.org