Insert text into append query field

[AccessFreak via AccessMonster.com]

Append Query name: "qry_employee_archive"

table.employee and table.arc_employee are exactly duplicates except table.
arc_employee has an extra field call "reason". This means the reason the
record was archived.

When "qry_employee_archive" runs to append data from table.employee to table.
arc_employee, I would like text (i.e., "No Longer Employed", "Transferred",
etc.) to added to the "reason" field in table.arc_employee.

I can specify the text based on when and where the append query run just need
to get that text inserted.

Thanks in advance!

 

[KARL DEWEY]

Better than using a separate table is to have one field for Archive (Yes/No -
default No) and one for reason not active.

Have an event/macro to prompt & update (SetValue) when the Archive field is
changed.