How do I count values in Access

[Todd Maurer]

Geez, I'm dense as I can't do something that seems so simple.

In Excel I could set up a pivot table to count the number of occurances of a
value in a table. If the values were numerical I could also total them.
Problem is that file I need to analyze is a .CSV file with more records than
Excel allows rows.

I can import the table into Access fine. I tried a pivot table, but I
don't see a way to add a "count" to an Access pivot table, like I can with
Excel.

Todd

 

[Mike Labosh]

I can import the table into Access fine. I tried a pivot table, but I

don't see a way to add a "count" to an Access pivot table, like I can with
Excel.

Make a Select Query that does this:

SELECT COUNT(*)
FROM YourTable