One to Many Query

[pbDudley]

Hello

I have 2 tables, 1table has all unique records with a unique record field that I can link to a table with many records per unique value

I want to create a query or VB code, that would return how many unique records to values



For example, this would be my unique record: R-7777
R-7777 would be connected to a table that has many and return this:
ID Value
R-7777 W
R-7777 X
R-7777 Y
R-7777 Z
S-6789 EE
S-6789 GG

I would want a way to have the query return ID: 2 Value: 6
I researched and I see DCount but this appears to just be adding up all of my Unique Records together,
Any thoughts on how to single out the unique records
thanks

[aytee111]

Create a totals query and count the number of records:
- in query design, top left is an icon that looks like a capital E
- click on that and it will add a new line to the query
- under the ID field select Group By
- under any other field select Count

[pbDudley]

Ok thank you, Ill try to work with the totals and get it to work, thank you!