Rollup Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that is tied to many relationships, however due to the immense
amount of records I created a field called "show". Once this field is
checked (yes/no) a query is then used to present those records. My problem
is I still want users to have the ability to pull down the rollups within the
query just like you would if you used a table. I have tried using the
subdatasheet settings, but the query loses all referential integrity and
shows them all. How can I get a query to rollup just like a table?
 
I figured it out. Simply go into the properties section of the query. Add
the first linked table to subdatasheet name and enter in the linked field
name in Link Child and Link Master. It works fine and a query can be used to
summarize rollups.
 
Back
Top