DB Query

[ldiuf]

I was wondering how I would query a db for some stats. In other words, count how many entries in the DB that have a certain defined aspect, and then it spits the result out in numerical form. I.e. "There are 37 instances of ??? found in field ??? of the DB and 42 instances found in field ??? for a total of or difference of ??? in the database (access2000)"

That's pretty much what I want to try to do. Any pointers or tutorials or just plain already done, anything, would be great.

Thanks in advance.
Larry
ldiuf@hotmail.com

[Roy Sinclair]

Something like this?

select count(DBFieldName) from DBTableName where DBFieldName = "???"

For multiple fields you'll have to run multiple queries.