R
Rita Brasher
I have a database for several different cities. The databases are
identical except for their title. I am trying to combine the results of
an append query added to each database so that I end up with one table
with the information from ALL cities. I have created a column in the
"write to" table titled "PORT_ID". In the append query for each city,
I've put in a column which I want to populate when the query is
executed. I do not know the correct syntax for this step as I am
continuously prompted to fill in the PORT_ID for each city. Once I type
in the PORT_ID again, the append query works wonderfully.
How do I code the PORT_ID in the append query so that it writes to the
external table without prompting me.
Thanks in advance for any help you can provide!
Rita Brasher
Project Engineer - Int'l MIS and Training
FedEx Express
identical except for their title. I am trying to combine the results of
an append query added to each database so that I end up with one table
with the information from ALL cities. I have created a column in the
"write to" table titled "PORT_ID". In the append query for each city,
I've put in a column which I want to populate when the query is
executed. I do not know the correct syntax for this step as I am
continuously prompted to fill in the PORT_ID for each city. Once I type
in the PORT_ID again, the append query works wonderfully.
How do I code the PORT_ID in the append query so that it writes to the
external table without prompting me.
Thanks in advance for any help you can provide!
Rita Brasher
Project Engineer - Int'l MIS and Training
FedEx Express