List By "Field"

C

Casey P

I want to have a query display a list of certain items per a certin item.

For Expample:
It come out like this now
Florida
Florida
Florida
Iowa
Iowa
Minnesota
Minnesota

I want
Florida 3
Iowa 2
Minnesota 2
Nebraska 0
California 0
S. Dakota 0
ect........

Any Ideas
 
D

David Cox

A simple group query with a count field will do this. Group on State.

The sigma (sideways M) symbol makes a simple query grouped in design view.
 
A

Allen Browne

Create a query using this table.

Depress the Totals button on the toolbar.
Access adds a Total row to the design grid.

Drag your field into the design grid twice.
Under the first one, accept Group By in the Total row.
Under the 2nd one, choose Count.
 
Top