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

80,919
32
145
234

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,239
7
48
59

Count certain record in database

2 Answers2