List By "Field"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem Binding Data to DROP DOWN LIST CONTROL 5
Count # of classes by month by local 6
Los Angeles Movers - Moving Company 4
Update query gives wrong results 1
Calculated Item causes undue repitition in pivot table 2
Combo Box: List of 50 States, want to type A and get Alaska, type. 1
Return US State Name or Territory from USPS Abbrevation - an example 3
Using Visual Basic Net as front end - Access as back end 18

Back
Top