
April 28th, 2004, 09:09 AM
|
|
Registered User
|
|
Join Date: Apr 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Queries based on date range from user
Hi,
i want to be able to find a number of items based on a date range given by a user.
I have created a form with two unbound text labels, one for entering the date from part
and the other for entering the date to part. Once the dateto label goes out of focus, i have a macro
which calls the date range query. The date range query has as it's base or source table a query which has all
the possible fields in the database. I use the Between operator in the query and is written as such:
Between [Forms]![formdaterange]![txt_label_datefrom] And [Forms]![formdaterange]![txt_label_dateto]
However I don't get any results. Can someone please help me create a proper query for this or at least direct me
to a site which has the necessary info w.r.t my problem. ThANKs a lOT.
Indian Elvis.
|