I have a data base that list all my sales calls when they were made and subject etc. I have a button that I click to make a report that list them all. Is there a way to make it so that when I click the button it asks to put a start date and end date for the calls so that it doesn't list them all. Thank you for your help.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Call dates
- Thread starter lsearcey
- Start date
SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
Yep. Let's assume that your report is based on MyQuery, and that you trigger it from MyForm.
To this form, add 2 textboxes: StartDate and EndDate. Format both of them as dates (I usually pick Medium Date). Save the form.
Now open MyQuery in Design view. Go to the CallDate field (or whatever you named it, and in the Criteria line, enter this:
Between Forms![MyForm]![StartDate] And Forms![MyForm]![EndDate]
(substitute the correct name for MyForm...). Close and save the query.
Now launch the form, enter dates in the StartDate and EndDate fields, and check it out.
Denis
To this form, add 2 textboxes: StartDate and EndDate. Format both of them as dates (I usually pick Medium Date). Save the form.
Now open MyQuery in Design view. Go to the CallDate field (or whatever you named it, and in the Criteria line, enter this:
Between Forms![MyForm]![StartDate] And Forms![MyForm]![EndDate]
(substitute the correct name for MyForm...). Close and save the query.
Now launch the form, enter dates in the StartDate and EndDate fields, and check it out.
Denis
Upvote
0
Similar threads
- Solved
