create several tables at once automatically

[joe789]

Hi Folks,

As a non-profit governmental local agency, we must conform to changes imposed by the powers-who-be. One of these changes is our extracts: currently, we receive one extract per business unit. This works very well. However, in a few months, we will be receiving one very large extract that has all the individual business unit extracts in it. In a sense, with the one field that identifies the business unit, I will be able to make-a-table-query and create seperate extracts/tables one-by-one for each business unit to mimick the extracts we received before the change took place. Is there any easy way, a macro or query, once ran will automatically generate an unduplicated unique list of values in the business unit field and upon that information unique tables would be created for each one of the business units automatically? Is this even possible? I don't know VBA that well, so a SQL Query or macro would be great if possible! I would greatly appreciate any help I can receive with this problem.

Thank you,

Joe

 

[FoFa]

A single query won't do it, but you could use a VBA loop to retrieve unique BU codes from your table, use that as your loop control and run a query for each unique value with a append or make table query.