Help with Simple Update Query

[gbs01]

I have one table called EDIDB.
It has 2 fields: ISBN & UPC.
Some of the UPC fields are blank.

How do I use the query grid to Update the UPC field with the ISBN when the UPC is null.

Thanks in advance for your help!
jlig

 

[PHV]

UPDATE EDIDB SET UPC = ISBN WHERE UPC Is Null;

If UPC may be blank or empty or Null, the slower version:
UPDATE EDIDB SET UPC = ISBN WHERE Trim(UPC & "") = "";

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[gbs01]

Thanks to PHV!

You make it seem so easy....
jlig