Chris T.
|
| Posted: 02/10/2006, 12:26 PM |
|
Using CCS 3.0.2.1, Access DB, XP.
How can I query my database between two dates that a user inputs?
I can pull all records between my example dates (1/1/2005 and 1/31/2005) just fine. How do I set up a search form? or other buttons/textboxes to have the query search between two dates supplied by user?
At first I tried to modify the search box, adding another textbox, then having the query..... Date_Issued between {Textbox1} AND {s_Date_Issued}.................
(s_Date_Issued was the default date textbox from when I created the report and specified a search dialog box)
Any help would be appreciated.
|
|
|
 |
Tony P.
|
| Posted: 02/12/2006, 7:39 PM |
|
I would liek help with this questions as well. Thank You
|
|
|
|
Chris T.
|
| Posted: 02/13/2006, 9:42 AM |
|
I figured it out, Tony. I made a report with report builder, and made two date search fields.
In the visual query builder, I have: Date >= s_SearchField1 (beginning date AND
Date <= s_SearchField2 (ending date)
and it worked for me.
|
|
|
|
|
