create table query

[coley]

Hi

Is there a quick way to split up a table into many other tables? I want to split the table by Client Number, so all the Clients with 1234, for example, are in a table called Client1234

I know the very long winded way, creating a ‘Create New Table’ query, inputting the Client Code criteria each time.

Is there a better more efficient way?

Thanks

coley

 

[sonny]

Why would you want to create more tables than is needed?

 

[coley]

because its what the 'Business' wants, believe me, i have asked the same question time and time again.

so is there a quick way, as i have over 100 tables to create.

 

[Mile-O]

Okay, it's "what the business wants" you say. Have you asked why the business wants this. You'll find they have no concept of the tool and are only interested in the output. The business doesn't care about the process of getting to the output.

 

[neileg]

I agree with the other wise contributors, but would add the following observations:

1. What you describe is easilly obtainable by using a query instead of a table. If properly written, your users won't know the difference, and you can keep your single table.

2. You users shouldn't be able to see the tables anyway.

3. The Business doesn't understand realtional databases and they are thinking in Excel terms.

 

[coley]

oh yes, the business have no clue, it is all output, output.

thanks anyway

 

[Mile-O]

oh yes, the business have no clue, it is all output, output.

I can't decide whether that is sarcasm or you now realise it to be the truth.

 

[coley]

not sarcasm, i was just agreeing with you, always been the same but they wont change. Thats life!!

 

[Mile-O]

It's just that the see the output in their head and typically don't know how it's arrived at. As neil says, queries are the way to go.