I need to be able to count occurrences of certain fields

[JimJones]

Hi,

I'm trying to figure out how to count the occurrences of one of 3 fields in a table, using a query.

The table, though rather long, has only 3 fields.
I'm using Access 2000, and one of the fields has an alpha value.

That alpha value may occur many times.
There is another field (numeric), that may change a few times, when the same alpha field is in that record.

I want to be able to count how many different numeric values that a given alpha entry has, in the whole table.

I hope that makes sense.
I appreciate the help.

Jim

 

[Pat Hartman]

I want to be able to count how many different numeric values that a given alpha entry has, in the whole table.

Select AlphaField, Count(*) As CountOfNumericFields
From YourTable
Group By AlphaField;

Or if you want a count of Each numeric value:

Select AlphaField, NumericField, Count(*) as CountOfNumericFields
From YourTable
Group By AlphaField, NumericField;