Make-Table Query Problem

[purceld2]

I have a Make-Table Query which every time I run it first deletes the existing table then recreates it. The problem I have is, I have any query which runs against the table which gets deleted.

When you open the query the field references are missing. How can I get round this problem?

Does Make-table have to delete the table can it not updated it?

Thanks in advance

Desmond

 

[pbaldy]

Presuming the fields remain consistent, instead of a make table query, run a delete query to empty the table then an append query to populate it.