Update Query

[Guest]

Hi - I am working with Access 2003 and I want to update one field in one
table to yes - how do I do this?

For example, I have a table listing all of people who hold a brokers license
or insurance license and sometimes both. At one time I would like to update
all of the people who hold an insurance license in that one table - can it be
done?

Thanks.

 

[Carl Rapson]

Hi - I am working with Access 2003 and I want to update one field in one
table to yes - how do I do this?

For example, I have a table listing all of people who hold a brokers
license
or insurance license and sometimes both. At one time I would like to
update
all of the people who hold an insurance license in that one table - can it
be
done?

Thanks.

Is the insurance license field a Yes/No field? If so, this will set every
record to True (Yes):

UPDATE

SET [insurance license]=True;

If it's a text field, this would work instead:

UPDATE

SET [insurance license]="Yes";

To use SQL such as this, create a new query in Design view, Cancel the
dialog for selecting tables, then switch to SQL view. You'll see a blank
form where you can type in and execute SQL statements.

Carl Rapson