HELP! count if

[mac3]

Hi I have a database with about 250 records in it I need to
count a text in a field and if the text is say "a" I want it to count it but if it says "d" I dont want to count it. What is the easiest way of doing this???
Please save my life and help out or tell me of a good book that might help.

p.s assume I am stupid when explaining.

Thanks squillions.

 

[tomschafer]

The easiest way would be to use a query. Such as...
select
count(*)
from
[TableName]
where
[FieldName} Is Like "a*"

You may want to do some reading on wild-cards though.