Re: Repeating and item in a column

On Tue, 31 May 2005 16:39:01 -0700, "faxylady"
<faxylady@xxxxxxxxxxxxxxxxxxxxxxxxx> 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 data*** 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]
.