make table query?

[healeyr]

Hi everyone,

I have got a couple of make table queries and everytime I run them it says the query will be deleted before I continue.

I obviously don't want my querys to be deleted - how can I stop this from happening?

Thanks a lot!

 

[Brianwarnock]

Are you sure its not an existing table of the same name as the one being created, not your query, that will be deleted.

Brian

 

[gemma-the-husky]

if you are making a table - then of course it will delete any pre-existing table of the same name

 

[Brianwarnock]

if you are making a table - then of course it will delete any pre-existing table of the same name

Didn't I say that?

Brian

 

[healeyr]

It's the queries that I don't want to get deleted - I'm pretty sure my original question says that...

 

[raskew]

Hi -

It'd be a little easier to evaluate if you'd post your code.

Best wishes - Bob

 

[healeyr]

there is no unique code, it started off as a select query and I obviously turned it to a make table query.

It's ok now though I found a cleaner and quicker way of doing things without having to make tables.