Counting different values in a field

  • Thread starter Thread starter George Reamy
  • Start date Start date
G

George Reamy

I have a lawsuit database, and I need to count by category
the different sorts of lawsuits in it (e.g., workmen's
comp, damages, damages and personal injury, etc.). How
would I do that? All I can think of is that I would do it
in a report or something.

Thanks!

--George
 
George,

Your database should look something like:

TblLawsuitType
LawsuitTypeID
LawsuitType

TblLawsuit
LawsuitID
LawsuitTypeID
Client
etc

One-to-One Relationship between LawsuitTypeID in both tables.

You then create a query that includes both tables pulling down LawsuitType from
TblLawsuitType and LawsuitTypeID from TblLawsuit. With the query still in design
view, click on the Sigma button on the toolbar at the top of the screen. Then go
down to the LawsuitTypeID field and in the drop down change Group By to Count.
Run the query and you will get what you want.
 
Back
Top