Query Report - Auto count for postcode ....

[shellie]

Hope someone can help, I'm new to access.

I need to generate a report from my database; that will
count for ANY postcodes and give me a total without my
manually typing in which postcode to count (for a
country - There are thousands). It has to go through my
postcode field.

ie:
0123 = 10 rows counted for postcode '0123'
0124 = 5
0200 = 8
0250 = 1
9999 = 20

in addition to that first report; I'm then required to
make an report / filter all postcodes meet the minimum
requirement (could be 10 or 20? not sure at this point).

Then with this lot; I have to do a mail merge; as well as
a mail merge the those that were under the requirement of
having 10 rows of the same postcode; different clients.

Am puzzled how to go about it; can someone please point
me in the rite direction?

 

[Guillaume Hanique]

Hello!

Create a query by design view. Add the table that contains the
postcodes. Double-click twice on the postcode field. This gives you
two columns with the postcode.

In the toolbar of the query builder, there is a Greek sigma sign.
Click it. There is a new row in your query builder, where it says:
GroupBy. For the second postcode, change this to Count.

Run the query.

Et voila! The first column is the postcode, the next column is the
number of times it appears.

Hope this is correct and hope this helps.

Guillaume Hanqiue.