Hi everyone -- I've enjoyed being a member of this group for several years but I've never posted much.
I am trying to run several "make table" queries on a single table to create several small tables. I'm using the "Name" field for the criteria in the query -- so one table for every name. Could someone help with an example of code, or perhaps just something easy that can be used in SQL to do this? The only alternative I can think of is to manualy create several queries (one each for 340 names) and that will take forever. Any clues on how this can be done? Maybe a subquery that reads each name and inserts into a WHERE clause? Thanks -- I asked this before in a different way but I guess I either didn't word it well or nobody here knew the answer. :-) Reg
