Re: [SPAM SUSPECT] [H] MS Access question

[Thane Sherrington]

At 09:31 AM 07/11/2006, Brian Weeden wrote:

What I was looking for with the counting was if there were 10 A1s in
that field in the entire database, I wanted it to show the number.

SELECT Count(FieldName)
FROM TableName
WHERE (((FieldName)='A1'));

T