Counting records on multiple query macros with spooled output

[sungn]

I inherited an MS Access DB that has a form that runs 88 reports set up as macros that then spool data as an export to separate spreadsheets. As this process needs to be run weekly, I need a way to count the number of records in the output for each of the 88 reports, so I can compare from week to week the progress. The output is not stored in tables.

I'd like to have a separate table with the name for each query report that gets loaded with record counts every week the process runs.

Do I need to convert the macros to VBA and edit the sql to include some kind of counter?

 

[genomon]

This forum is for Visual Basic (not VBA) versions 5 & 6. You may find better help in one of the Access forums, such as forum181 .

Beir bua agus beannacht!