Append/Update in one query ?

[James Houston]

I'm running a query in an Access 97 database that appends records from
table1 to table2. Table2 has fields that table1 doesn't have. What I want
to do is update the unreleated fields in table2 for the records that are
appneded from table1. Say the two tables have the following structures:
Table1 Table2
Name Name
Address Address
City City
State State
Zip Zip
PrintLabel

What I want to do is set a value for PrintLabel when I append a new record.
Does anyone know how to make this work? Thanks in advance.

Jim

 

[Van T. Dinh]

Yes. For example, if the Field PrintLabel is a Boolean
Field (in Table2) and you want to set the value of this
Field to True for the Records to be added, create a
calculated Field in your Query like:

SrcPL: True

In the "Append" row, specify it to be the Field PrintLabel
in Table2.

HTH
Van T. Dinh
MVP (Access)