auto fill a field

[Sal]

am using Access 2003 - I have added several new field to a table - they are
all "yes/no". I would like one specific field to all have Yes as the data.
there are 250 records and an auto fill would save a lot of time!

any suggestions

Sal

 

[Wayne-I-M]

Hi

Create a query and use this (if it is a Yes/No field)
UPDATE TableName SET TableName.YesNoField = -1;

or - if you have a field with the TEXT "yes" or "no" then use this
UPDATE TableName SET TableName.YesNoField = "Yes";


Change TabeName and YesNoField to what they really are in your application

 

[Jeff Boyce]

Sal

Take a look at using an update query.

By the way, if you have "several new [yes/no] fields in a table", there's a
chance you've treated Access like a spreadsheet. It can work, but both you
and Access need to come up with work-arounds.

If you'll describe the underlying data a bit more specifically, folks here
may be able to offer more specific suggestions...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Sal]

Thanks to all - the update query worked fine!

Sal

Take a look at using an update query.

By the way, if you have "several new [yes/no] fields in a table", there's a
chance you've treated Access like a spreadsheet. It can work, but both you
and Access need to come up with work-arounds.

If you'll describe the underlying data a bit more specifically, folks here
may be able to offer more specific suggestions...

Regards

Jeff Boyce
Microsoft Office/Access MVP

am using Access 2003 - I have added several new field to a table - they
are
all "yes/no". I would like one specific field to all have Yes as the
data.
there are 250 records and an auto fill would save a lot of time!

any suggestions

Sal