counting instances

  • Thread starter Thread starter Guy Story
  • Start date Start date
G

Guy Story

Hello everyone, I am new to Access and seem to be banging my head against
the wall trying to figure out how to make Access count instance something
happens in a specfic field. For example, I have a column in my table for
insurance companies. I need to be able to count how many times a specific
company appears in my table. Can Access count and report on the amount of
postings and handle new companies being added on the fly or will a seperate
report for each company be required? I know how to do this in Excel but
this database will be accessed by several people needing read/write at the
same time.
 
Guy said:
Hello everyone, I am new to Access and seem to be banging my head against
the wall trying to figure out how to make Access count instance something
happens in a specfic field. For example, I have a column in my table for
insurance companies. I need to be able to count how many times a specific
company appears in my table. Can Access count and report on the amount of
postings and handle new companies being added on the fly or will a seperate
report for each company be required? I know how to do this in Excel but
this database will be accessed by several people needing read/write at the
same time.
Click to expand...

Base the report on a Totals (Group By) query. E.g.

SELECT Company, Count(*) As CompanyCount
FROM the table
 
Back
Top