Show only records with Count = 1 in Query Results

[veaux]

Might not have explained this correctly in subject, but query results
look like below:

Name ID Phone

Bill 001 123
Bill 001 234
Bill 001 456
Sam 002 999
Mary 003 888
For the above, which is now a "unique values query" I only want to
show records where there is only 1 ID. So with the above, I'd only
want Sam and Mary output. I would not want Bill to be output at all
since he has 3 different phone numbers which is why he's showing up 3
times. I thought I was supposed to tell Access if Count = 1 for ID to
display but that's not working or I'm not doing correctly.

Thanks,
Darrell

[Scott]

you need to create a query that does a count of name, then join that query
with your current query and only show those records with a count of 1

<ve***@aol.comwrote in message
news:11**********************@q69g2000hsb.googlegr oups.com...

Might not have explained this correctly in subject, but query results
look like below:

Name ID Phone

Bill 001 123
Bill 001 234
Bill 001 456
Sam 002 999
Mary 003 888
For the above, which is now a "unique values query" I only want to
show records where there is only 1 ID. So with the above, I'd only
want Sam and Mary output. I would not want Bill to be output at all
since he has 3 different phone numbers which is why he's showing up 3
times. I thought I was supposed to tell Access if Count = 1 for ID to
display but that's not working or I'm not doing correctly.

Thanks,
Darrell