How can I break on a partial field while returning counts?

[Guest]

I need to create a query that will return counts for partial zip codes. For
example, I need the counts for each different 999xx combination, as I am only
concerned with the first 3 digits of the zip code. How can this be done?

 

[Duane Hookom]

Use a totals query that groups by Left([ZipCode],3).

 

[Guest]

Thanks Duane!

Use a totals query that groups by Left([ZipCode],3).

--
Duane Hookom
MS Access MVP

I need to create a query that will return counts for partial zip codes.
For
example, I need the counts for each different 999xx combination, as I am
only
concerned with the first 3 digits of the zip code. How can this be done?