I need to process records from 2 tables in an Access database, calculating counts of occurrences of various values in some of the fields in those tables and then output those counts to an Excel file.

I know how to connect the Access database and tables to data controls, but don't have any idea how to go through the tables accumulating the counts. Also, don't know how to output those counts to Excel.

Assuming I know zip about this, anyone able/willing to help me figure out how to do this?

TIA,

Don Goyette