With Acc 2007 I have a table of Well Spots. This includes lat/long for the location of wells.
There are 135000 records of wells in 55 counties.

I'd like to automagically do a query (or something) to MakeTable for each county with the wells in it. The table has 27 fields in each record (County name, county number, lat, long, etc).

We could do a loop using the county number to key on to create the next table.

Would we use a macro to execute sql query, or how?