querying a recordset

[GerryGoldberg]

I would like to select some records like:

set rst1 = dbs.openRecordset("SELECT * FROM tableA WHERE state = 'OH')

Then, based on the resulting recordset, I would like to do an additional query, like:

set rst2 = "COUNT (*) FROM (the recordset rst1) WHERE City='CLEVELAND'"

How can I reference rst1 in my second query?

Thanks,

Gerry Goldberg

 

[Dzidze]

Why don't you just make your querry on the city? (with some Inner Joints)
then, x = rst1.RecordCount ''Life is like a box of chocolate...''