Postcode group counting in query

[chedd via AccessMonster.com]

hi

At present i have single columns for all my postcodes i:e ST1 to ST17 with
Other, Not Stated.

Is there an easier way in query to just have one cloumn counting all and this
will produce just one column with data instead of 20 seperate columns.

Thanks for help in advance

Chedd

 

[KARL DEWEY]

SELECT [postcodes], Count([postcodes])
FROM YourTable
GROUP BY [postcodes];

 

[John Spencer]

It sounds as if you have 17 columns that contain the same type of data.
If so, your design is faulty.

You should have a separate table to contain each postcode along with a
field (or fields) that links the postcode entry to your current table.
I can't give you further advice, since I have no idea how you would know
that ST2 and ST11 are associated with your current table records.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================