Repeating and item in a column

I have imported several tables into a database. One of the columns is the
city column. All of the records that are in the table are related to one
particular city. Is there a way that I can enter the city in the very first
record and copy it down the city column throughout the entire table? Seems
like I remeber this being a feature in Access.

Keep in mind these tables have already been imported with data in them. I
want to add a column with the same entry for each record without having to
enter them individually.

Use an Update query to populate the field.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"faxylady" wrote in message
...
I have imported several tables into a database. One of the columns is the
city column. All of the records that are in the table are related to one
particular city. Is there a way that I can enter the city in the very
first
record and copy it down the city column throughout the entire table?
Seems
like I remeber this being a feature in Access.

Keep in mind these tables have already been imported with data in them. I
want to add a column with the same entry for each record without having to
enter them individually.

On Mon, 30 May 2005 14:39:01 -0700, "faxylady"
wrote:

I have imported several tables into a database. One of the columns is the
city column. All of the records that are in the table are related to one
particular city. Is there a way that I can enter the city in the very first
record and copy it down the city column throughout the entire table? Seems
like I remeber this being a feature in Access.

Keep in mind these tables have already been imported with data in them. I
want to add a column with the same entry for each record without having to
enter them individually.

Just add the new City field, set its Default property to the desired
city; and then run an Update query to update it to the desired city
for the existing records.

John W. Vinson[MVP]

Can you tell me how to do an update query? None of the sources I am using
gives me explicit directions on doing them.

"John Vinson" wrote:

On Mon, 30 May 2005 14:39:01 -0700, "faxylady"
wrote:

I have imported several tables into a database. One of the columns is the
city column. All of the records that are in the table are related to one
particular city. Is there a way that I can enter the city in the very first
record and copy it down the city column throughout the entire table? Seems
like I remeber this being a feature in Access.

Keep in mind these tables have already been imported with data in them. I
want to add a column with the same entry for each record without having to
enter them individually.

Just add the new City field, set its Default property to the desired
city; and then run an Update query to update it to the desired city
for the existing records.

John W. Vinson[MVP]

On Tue, 31 May 2005 16:39:01 -0700, "faxylady"
wrote:

Can you tell me how to do an update query? None of the sources I am using
gives me explicit directions on doing them.

You need better sources... g

Create a new Query. Base it on your table. Select only the City field.

Use the Query menu option, or the query-type tool in the toolbar (it's
near the middle, just looks sort of like a datasheet and has a
dropdown) to change the query to an Update query.

A new row will appear in the query grid labeled Update To.

Type "Schenectady" (or some other city of your choice) on this line.

Run the query by clicking the red ! icon.

You can put criteria on the Criteria line to make this a selective
update - with no criteria, it will update every row. Use with caution,
if the field you're updating contains data already it will be
permanently and irreversibly overwritten!

John W. Vinson[MVP]