append query error (1 Viewer)

murray83

Games Collector
Local time
Today, 01:02
Joined
Mar 31, 2017
Messages
728
hi folks having slight issue

have just found out that my query which archives to a separate table hasn't been running :banghead:

i go into the front end and try and run it myself and am given the following/attached message

all help appreciated

ps

forgot to say its a split database
 

Attachments

  • query error.png
    query error.png
    55.4 KB · Views: 35
Last edited:

Galaxiom

Super Moderator
Staff member
Local time
Today, 12:02
Joined
Jan 20, 2009
Messages
12,849
Your query is adding records that have already been archived.

Put both tables in the query.
Do an outer join from the source to the destination on the key.
Add a condition that the key field Is Null in the destination table.

BTW It is rarely necessary to archive records. Generally the "archived" records can be left in the original table and avoided using a Where in the select query. Sometimes it can be on an Archive boolean field.
 

murray83

Games Collector
Local time
Today, 01:02
Joined
Mar 31, 2017
Messages
728
thanks for the reply but having checked my table when was made aware of this and again just now they haven't been archived, in fact hasn't run the query since the 10/05/2018

edit :

sorry after a closer look it would seem that the key wasn't unique somehow so need some maintenance at a later date for now have just commented out the options
 
Last edited:

Users who are viewing this thread

Top Bottom