yankel1
asked on
How do I make this query?
I have three related tables, but I want all information from each person shoaled be in one line per MasterID.
Please look on sample database.
Sample.mdb
Please look on sample database.
Sample.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
But it does answer your original question.
Anyway. you would need to set up a script the query on the fly using a recordset loop to build each of the Sub-Queries.
How is your VBA? What is the endgame - form, report built on top of the data? What if there are a huge number of associations?
How would you dynamically setup the report/form on the fly to add/remove controls labels dynamically for field names based on a query at runtime?
Some ideas for good but separate questions to ask the experts.
Anyway. you would need to set up a script the query on the fly using a recordset loop to build each of the Sub-Queries.
How is your VBA? What is the endgame - form, report built on top of the data? What if there are a huge number of associations?
How would you dynamically setup the report/form on the fly to add/remove controls labels dynamically for field names based on a query at runtime?
Some ideas for good but separate questions to ask the experts.
ASKER
But this only works if I know all Associations when I make the query, what if I dont have all associations?