Query Count

[pwoodj]

I had no luck searching for this, maybe I could get some help.

I have a column, which contains values of "A" and "T", I need to have a count of all the "A" a "T" records.

I have no experience with expressions, so any help would be great !!

thanx
pete

 

[pbaldy]

One way:

SELECT Sum(IIf([FieldName]="T",1,0)) AS CountOfT, Sum(IIf([FieldName]="A",1,0)) AS CountOfA
FROM TableName;