for each row in a query I want to get a count or list of another query same table.

[jalewis999]

I have a table that includes an iD No. (Auto) index and a sponsor's ID No. For each ID No. I would like a count of the Number of Sponsors he has in the table I assume by finding the number of entries showing the current ID No. as the sponsor.
I have tried using a Dcount as an expr: to print on each line, but I can't seem to get it right.
I know it could be done by using NEXT and using Dcount or another query in the code, but I was hoping for a cleaner one query aproach.


Thanks for any ideas.
I have the latest ver of Access.

[JoeM]

How about doing an Aggregate (Totals) Query, grouping on the one field, and doing a count of the other field?