auto fill a field

  • Thread starter Thread starter Sal
  • Start date Start date
S

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
 
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
 
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
 
Thanks to all - the update query worked fine!

Jeff Boyce said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top