I figured the well table did have the appropriate county number in it. That would be the way to capture all the records for just one county. That is why the original query that will be used to make each of the 55 county tables needs a parameter in the criteria row of the county number field that is pointing to a field on a form. That field on "a form" is the field that your VBA code will update while reading, one record at a time, a table (or query) that has 55 records in it, one for each county. By moving that county number from the table (or query) into the field on the form, then running the query that will be a Make Table query, you can make a table for each county.