<div>
I was hoping to do all of this in one query, but your solution works fine. Thanks for your help!
</div>


I was hoping to do all of this in one query, but your solution works fine. Thanks for your help!

<div>
I thought it might be simple. I guess I just couldn't see it. Thanks again.
</div>


I thought it might be simple. I guess I just couldn't see it. Thanks again.

<div>
<div class="content wysiwyg-content">
I have a query which returns a individual records where a parent-child realtionship exists. I would like to count the distinct parent records and distinct child records. Each parent can have &gt;1 child, but for some reason the number of parent records &nbsp;= child records which is incorrect. Here is an example<br />
<br />
Parent Record 001 + Child Record 001<br />
Parent Record 001 + Child Record 002<br />
Parent Record 001 + Child Record 003<br />
<br />
The result I am looking for would be 1 Parent + 3 Child on a single row returned in my query. It should be fairly simple, but I am stumped. <br />
Thanks in advance for your help.<br />
Chad
</div>
</div>


I have a query which returns a individual records where a parent-child realtionship exists. I would like to count the distinct parent records and distinct child records. Each parent can have >1 child, but for some reason the number of parent records  = child records which is incorrect. Here is an example

Parent Record 001 + Child Record 001
Parent Record 001 + Child Record 002
Parent Record 001 + Child Record 003

The result I am looking for would be 1 Parent + 3 Child on a single row returned in my query. It should be fairly simple, but I am stumped. 
Thanks in advance for your help.
Chad

Count distinct parent and child records

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.