Complex Query

[Klubby]

I am using the "Top Values" feature to query and pull our top 50 A/R clients. This is easy and the report based on this report is fine...

We have another field in the database that is used that labels client "family groupings."

My question is how to pull the rest of the family group in the detail if the client happens to fall within the top 50, when the rest of the family group does not. I want to show the whole family group if one of them falls within then top 50.

Is this possible? If so, Is it done within the query or on the report?

 

[FoFa]

I would use a subreport that pulls the distinct family groups that are in the top 50.

 

[Klubby]

thanks!

Now, I wonder where should I pull the data? The Top 50 query? A new query based on that query? I cannot seem to get the others listed since they are not in the top 50.

Also, where does the subform go on the report? Right in with the detail?

Thanks in advance for your help and expertise!

 

[Klubby]

Ok, I figured out my second query to pull all those other records from the family groupings if they happened to be in the top 50...

My problem is now the report. The report is grouped by account manager ascending, and then by A/R amount in descending order. I have NO idea how to incorporate the other groupings (second query) if they fall within the top 50 (first query). In other words, the results of those not in the top 50, but part of the family group should be listed right under the one that does fall within the top 50.

Is this even possible?