By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,952 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Simple Householding question

P: 1
I had a simple question about Access 2007. I'm working with voter databases, and I need a simple way to household the results of my queries by phone number and/or address. Nothing fancy, just a little code that I can use on the fly to only show me the unique records from a query, according to a field or fields that I chose for determining duplication.

Thanks,
Adam
Oct 8 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
I guess you need to explore the GroupBy query.
Just open a new query and place the field(s) you want to explore.
Next Press the "E" looking GroupBy button on the Ribbon and see the result.
By adding e.g. the unique key of the table and changing the "GroupBy" underneath that field into "Count", will give you the number of occurrences of that specific field or combination of the fields.

Getting the idea ?

Nic;o)
Oct 8 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.