Creating a postcode/regional report

[lsmcal1984]

All,

I am attempting to create a report that shows a breakdown of customers in regions.

I have created a customer table, where there is a postcode field.

I have created a postcodes/regions table that contains the first parts of postcodes and a corresponding region.

I have created a query that splits the postcodes up, that correspond with the first part of the postcode in the postcodes table.

Database is attached.

I want to count the number of times a region occurs - any ideas?

Thanks

 

[Beetle]

You already have a query that returns the first part of the post code from the Resposes table, so just create a Totals query that joins that query to the Postcodes table and use a Group By on Region and a Count on Region. I have reattached your db. See Query1.