In the above lesson at 15:30 Richard says"Unfortunately there isn't an easy way etc. However, instead of creating a second query I left it as it was but deleted ToBeArchived from the Append To: field and it worked perfectly. This seems a lot quicker and easier than creating a second query.
Kevin Robertson
@Reply 4 years ago
But without the criteria ALL records will be archived not just those marked True.
Maarten BrusselersOP
@Reply 4 years ago
I left ToBeArchived in with the criteria True but deleted only the append field value
Maarten BrusselersOP
@Reply 4 years ago
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 17.