Specify Table Name for Make Table Query

[LJtechnical]

Hi,

Can anyone tell give me an idea of how to run a make table query from a form thet gives the table the name from the contents of a field on a form.

At present it overwrites the table each time I run, but I want to create a range of tables dependant on the query results. Have found DestinationTable property help but unsure how to use this with Docmd.OpenQuery etc.

Thanks

 

[Crowley16]

erm, personally, I would do this using vba so that I could run checks for each create table...

but if you just want to use a query, then I suppose you can try a nested query:

CREATE TABLE (
SELECT blah FROM blah
)(fields...)

although I'm not sure if this is possible, just an idea

Procrastinate Now!