I am having problems creating a recordset and counting the number of
records therein at the time.
Lets say Database name = db
Table we're interested in = Table
Fileds we're interested in are x, y and z
So what's wrong with
Set rsRecordsetName = db.openrecordset("SELECT Count(Table.x) AS
TotalNumber, x, y, z FROM Table WHERE x = " & whatever
I keep getting the message "x not part of aggregate function or
If I remove Count(Table.x) AS TotalNumber, rsRecordsetName opens fine.
If I create a second recordset with just SELECT Count ... I get the
How, please, do I put the two together.