Append Query, New Column help

[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

 

[S.Clark]

Post the SQL.

The reason that you are ever prompted in Access for a field value is because
Access doesn't know what that column is, and rather than crash, it prompts.
(kindler, gentler crash)

Maybe because the destination table exists in another database (meaning
..mdb), it doesn't know that the field really exists until it actual fires
some info across the connection. Not sure how to overcome that, but again,
post your SQL and we'll eliminate the obvious first.