Access SQL Summary / Count Query

[desmond]

I am new to Access SQL and wondered if it is possible to summarise / count by field?

e.g. If I have a table as follows:

Post_Cd Status Type

1234 A1 Z
1234 A1 Y
1234 A1 Z
1234 A1 Z
1234 A2 Z
1234 A2 Y
1234 A1 Y
1234 A2 X
2345 A1 Z
2345 A1 Y
2345 A1 Y
2345 A2 Z

Is it possible to have a query that will provide the following summary / count:

1234 A1 Z 3
1234 A1 Y 2
1234 A2 Z 1
1234 A2 Y 1
2345 A1 Z 1
2345 A1 Y 2
2345 A2 Z 1

Can anyone help?

 

[MStef]

Look at "DemoSQLCountA2002.mdb" (attachment, zip).
Run Query1. I think it is what you need.

 

[desmond]

Look at "DemoSQLCountA2002.mdb" (attachment, zip).
Run Query1. I think it is what you need.

MStef, you are a legend.