Possible to connect a single report to multiple queries?

  • Thread starter Thread starter ghadley_00
  • Start date Start date
G

ghadley_00

Hi,

I have an MS access database where table entries are each assigned to 1
of multiple users. I also have the same report that shows summary data
about each user's entries as a single report. (So for X users I have to
maintain X different reports, that are are identical except for the
data source, which are X predefined queries).

1) Is there a way for me to maintain a single reports, and have the
datasource defined via a button event? (i.e. via VBA?) So on clicking a
button I could have the same report open with it's data source being
different predefined queries?

Thanks,

George Hadley
(e-mail address removed)
 
Sure. All you need to do is change the report's RecordSource property.

However, do you really need X predefined queries? Can you not simply use 1
query with a parameter for which user?
 
Thank you for the response.

1) any suggestions on how to set the recordsource property as part of
the form open button?

2) how does one define a custom query for this recordsource property?

Thanks,

George
 
Hi

Create a query from the query tab and save it. Then on the forms record
source property it will give you an option to use that query
 
Back
Top