Insert text into append query field

  • Thread starter Thread starter AccessFreak via AccessMonster.com
  • Start date Start date
A

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!
 
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.
 
Back
Top