
January 7th, 2005, 10:43 PM
|
|
Registered User
|
|
Join Date: Jan 2005
Posts: 4
Time spent in forums: 18 m 25 sec
Reputation Power: 0
|
|
First create the query, returning date and the fields you want. In the date column write BETWEEN [First Date] AND [Second Date]. This will prompt the user for the date range. Use the form wizard and build the form based on this query. Either use a command button to execute the query. Or use text boxes to have the user enter the dates, and set the text boxes equal to [Start Date] and [End date].
Quote: | Originally Posted by rfields How do I create a form that a user has to input a start and end date that queries a table. I have a date received field in my table and I want to be able to retrieve records telling me how many jobs that we have received over a period of time. How do I I link them together?. Second, how do I put a calendar on that same form where the user can click on a small calender that gives him the choice of clicking on a specific date versus typing the date in. |
|