Caroline

I don't want to do your homework for you. I don't mind helping you past sticking points but you need to make a reasonable effort first.

First, do a 'Compile Project' and resolve all of those errors. For instance sngRecords is not a Connection and is not required in the Connect sub.

Second, build an example of the SQL query you want in your access database. Go to SQL view and look at what it looks like. Now compare it to the strEmps that your code creates - you will spot several errors that need resolving.

Once you have those resolved, we can move forward with the rest of what you need to do.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia