Returning a count.

Question

Returning a row count from an already existing query?

select count(*) from
(SELECT *
FROM [original-data]
WHERE State="AB")
);

It looks like I need to work on the syntax. Can this be made to work? My intent is to return the number of rows from:

(SELECT *
FROM [original-data]
WHERE State="AB")

Thank You!

Answer 1

The query would be:

SELECT count(*)
FROM [original-data]
WHERE State="AB"

You can also use the DCount function. Look it up in the Help file.

---

-Tom. Microsoft Access MVP