Hello guys,
I need a query to update items which has been changed or new. I like to use an append query and an update query, but I do not know how I can start.
Best regards
Matthias
Hello guys,
I need a query to update items which has been changed or new. I like to use an append query and an update query, but I do not know how I can start.
Best regards
Matthias
in a new query,
bring in the table you want to change
using the icons on the bar, change the query to UPDATE query
dbl-click the field you wish to change
in the row: UPDATETO put the value you want the record to be changed to.
bring down any other fields if you need a WHERE clause.
save