Unanswered: Issue with selecting table as target for Append query
My database has a main table, called Helper. I copied this table (structure & data) to keep details of deceased helpers, and called it Deceased_Helpers. I then removed all bar 2 of the rows and removed a lot of unimportant columns.
I'm now trying to set up an append query to copy data from Helper to Deceased_Helpers when someone dies. On creating an append query, I'm asked which table I want to append to, but Deceased_Helpers does not appear in the selection list. I'm completely stumped as to why.