How to update a table from a qury

[GreekPatriot]

I am faced with a problem using the append query or the create-table query.

With the create-table query I loose the table formats whereas with the append query I get doublicate data or if I set the no duplicate field property, I dont get the current data on the table updated.

Is there a way to overide all data on the table withour recreating the table?

Cheers. Looking for an answer if there is one.

 

[GreekPatriot]

ok I have a solution.
I created two queries. A delete Query and an append query. So I created a macro to first run the delete Query and then to run the Append Query so all data are transfered to the table, by first deleting the current and I dont loose the format of my table.

Ciao