Community
Showing results for 
Search instead for 
Do you mean 
Reply

What are my unique entries in a Field, and how many records per each unique entry

New Member
Posts: 1
Country: USA

What are my unique entries in a Field, and how many records per each unique entry

I need some help with a Zip Code field in my database.

I'd like to (1) see the distinct zip codes I have in the database, and (2) see how may records are in each distinct zip code.

I know I can download it to Excel and see it easily there, but I'd rather be able to see a report of this information without having to go to Excel - IF possible.

Thanks for any ideas.

 

Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: What are my unique entries in a Field, and how many records per each unique entry

It could be done with an ACT! report.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129