Does anyone have a copy of a macro that gets the user to enter in a number of years ranging from 1971 to 2003 and gets them to choose a report for the info to go into then opens the report for the user with the wanted years information.
Macro help
- Thread starter User Name
- Start date
jeremie_ingram
Registered User.
- Local time
- Today, 15:55
- Joined
- Jan 30, 2003
- Messages
- 437
Cant think of a macro that would do that, but you could base a report off of a query and create a parameter that would request them to enter a start date and end date. Then the reports data would be limited to the scope of the dates entered.
Hayley Baxter
Registered User.
- Local time
- Today, 21:55
- Joined
- Dec 11, 2001
- Messages
- 1,607
You could use the openreport action, choose the query you are taking your data from and enter in the criteria section the criteria you need to open the query. You could have something like between [start date] and [end date]
Edit: Jeremie beat me to it (must be too slow at the typing tonight
HTH
Hay
Edit: Jeremie beat me to it (must be too slow at the typing tonight
HTH
Hay
Last edited:
R
Rich
Guest
Assuming these are contiguous dates then the methods suggested will work, if they're not you'll have to use a multiselect list box and build the criteria on the fly
