Designing a query that will produce multiple tables???

[joe73]

Is it possible in Access to design a query that will produce more than one table? If so, would anyone care to explain? What I want a query to accomplish is when everytime the customer number changes it creates separate tables. Is that possible for someone who does not have knowledge in VBA? Please help.

Thanks,
Joe

 

[kathryn]

OK, when the customer number changes do you want multiple tables created or do you want multiple tables updated? If you really want multiple tables created, could you explain a bit more of what you are doing? Kathryn

 

[joe73]

Thank you for responding to my question. I'm working on a forecasting project of 600 customers of last years booked and shipped per week. I've extracted the raw data that I need from an ODBC table. I've created a table that contains customer numbers, booked, shipped, Distribution Center numbers and dates. My objective is to separate and group the customers along with their data. I want to build one query that for everytime customer number change, it would create different tables for that customer. I'm hoping to avoid creating 600 queries.

 

[kathryn]

You can do this, although not in a query; you would have to use code. Basically, you would create a recordset from the table, sorted on customer number and each time the customer number changed you would start a new table.


However, I don't know why you would want to create separate tables for each customer. If you have all the customers in one table you can just use the customer number to pull out data for each customer as needed, using a query. You can use a parameter query, if you want, which will ask you what customer you want to see.

Kathryn

 

[ghubbell]

Joe, Please do everyone a favor and post your question once in one place. You will find more people willing to help you if you will follow this simple request. Thank you. Gord
ghubbell@total.net