If then in Access SQL or macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dksj67 - 21 Apr 2008 18:01 GMT

I would like to write a query or macro in Access 2003 that will go through a
table and perform the following function:

If text in FieldName starts with letter "Z" then make value in FieldName2 =
"". What is the quickest way to go about this task?

Dan Kreiling

Reply to this Message

Marshall Barton - 21 Apr 2008 18:56 GMT

>I would like to write a query or macro in Access 2003 that will go through a
>table and perform the following function:
>
>If text in FieldName starts with letter "Z" then make value in FieldName2 =
>"". What is the quickest way to go about this task?

UPDATE table SET FieldName2 = ""
WHERE FieldName Like "Z*"

When making this kind of semi global change to data, be sure
to make a backup copy of your data table so you can recover
the original data if anything goes off the rails.

Signature

Marsh
MVP [MS Access]

Reply to this Message