I have a report that I want to use for 5 different queries. I need the report to be the same each time, and each query has the same fields. Can I just make the report once, and change which query it looks at, rather than doing the report from scratch each time?
-
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.
Using the same report....
- Thread starter Techfi
- Start date
Are the 5 queries the same apart from filtering?
You can use just one query and pass differnt filters to it when you open it from a form.
Another option would be to use one query and use code to change its SQL or to change the record source of the form by code.
Peter
You can use just one query and pass differnt filters to it when you open it from a form.
Another option would be to use one query and use code to change its SQL or to change the record source of the form by code.
Peter
Upvote
0
Similar threads
