471,089 Members | 1,648 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,089 software developers and data experts.

Show only records with Count = 1 in Query Results

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

Jun 5 '07 #1
1 2330
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

Jun 6 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.