COUNTIF In Access

[amourdevin]

I was wondering if there is a way that you can have MS Access count the number of times a given value appears in an entire field. In MS Excel, I would use the COUNTIF function.

An example would be if you were a widget repairmen and wanted to display how many time a certain serial number widget had been in for repair. I do not mean a query to diplay the history for that serial number but a way to display the actual number of visits as a value (e.g., 2 visits, 5 visits, etc.).

 

[Golom]

Select SerialNumber, Count(SerialNumber) As Visits
From tbl
Group BY SerialNumber

Will show you one entry for each SerialNumber followed by the number of times that SerialNumber occurs in the table.