Sorry, Maybe I didn’t make myself clear. The recordset in question is retrieving all records from table oxadmain. The COUNT() function is needed to count a subset of records in order to perform calculations using other data from oxadmain.
The purpose of the recordset is NOT solely to count records, but to display info and perform operations using the results.
How would the syntax be in this case?
Thank you for your attention.