Mass change of data in table

[dksj67 via AccessMonster.com]

I would like to search a table (Table1) field for a specific text value (call
it FieldName2) that begins with the letter z. If it does then I would like to
make another field (Call it FieldName3) blank. What syntax would I use? this
is basically what I am trying to do:

For each record in table
If Left(Fieldname2) = z then
FieldName3.text = ""
End If
Next

Dan Kreiling

 

[Steve Schapel]

Dan,

Make sure you have a backup of your database, just in case...

Make a query based on the table, and include FieldName2 and FieldName3
in the query design grid.

Make it an Update Query (select Update from the Query menu).

In the Criteria of FieldName 2, enter:
Like "z*"

In the Update To row for FieldName3, enter:
Null

Run the query (click the toolbar button with the red [!] icon.