Append Query

[fenhow]

Hi, I am populating a table from a query, I have made it an append query.

Is there any way that when I run the Append Query it does not simply add more records but overwrites any existing data in the table it is appending to and then write the new records?

Thanks.

Fen How

 

[Kryst51]

use an update query instead.

 

[Kryst51]

And then run an append. You could set up a macro to do one then the other right after.

 

[fenhow]

Thanks, in the update query I am not sure how to do that, do I just change the existing query to an upate query and run it? Will it update itself from the existing data?

Thanks.

Fen How

 

[fenhow]

When I run it it says you must have at least one destination field.

Thanks.

Fen

 

[Kryst51]

I don't use update queries often, so am not sure how to guide you, I'm sorry for that. i know you have to put what you want to update to in the "Update to" row in the QBE, if it is info from a form, you could probaly put the same thing you would put in the criterie, something like [forms]![fieldname]....

Here is one tutorial.

You can also probably find some other threads. And someone may read that I was not able to help you with the actual query, and respond to this.

Also try using the google advanced search, and put this website in the browser filter, it gives you a lot of threads, that might help guide you.

 

[fenhow]

Thanks for your input, I think I will run a DeleteQuery first, clear out all records, then run the append query second and re-populate. Seems like this may work.

Thanks again.

Fen How