Count certain record in database

Question

How can I count the number of certain records in database using classic asp? For example, I want to count how many record are there for Car..I'm using ms access. need help. thank you.

You may want to see: http://stackoverflow.com/questions/1057175/how-to-count-records-in-asp-classic — J. Polfer, Sep 04 '09 at 20:18

score 1 · Answer 1 · answered Sep 04 '09 at 19:58

1

Yes.

SELECT COUNT(*) FROM Table WHERE Field = 'Car'

answered Sep 04 '09 at 19:58

recursive

83,943
34
151
241

score 0 · Answer 2 · answered Sep 04 '09 at 19:58

0

Is car a table?

select count(1) from car

Just like any other query.

answered Sep 04 '09 at 19:58

marcc

12,295
7
49
59

Count certain record in database

2 Answers2