Counting.. (1 Viewer)

[John Bull]

How can I produce a report that counts the number of times particular variables appear in a field.

The field is called "Types" and I have set it so that each record can take on 1 of the following three values:
"C/N & INV"
"IN & OUT"
"C/N"

regards

 

[Pat Hartman]

Select Types, Count(*) AS CountOfTypes
From YourTable
Group by Types;