Repeating and item in a column

[faxylady]

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.

 

[Douglas J. Steele]

Use an Update query to populate the field.

 

[John Vinson]

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]

 

[faxylady]

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]

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]