Replacing Field

  • Thread starter Thread starter isons via AccessMonster.com
  • Start date Start date
I

isons via AccessMonster.com

I have a table PRODUCTS.

Fields are

ProductNo
Description
Price
Vendor

There are 145000 records in this table. On some records vendor field is
filled with ABC.
I want to replace blanks with XYZ.

Sombody plz help
 
use an update query.

UPDATE Products
SET Vendor="XYZ"
WHERE Vendor IS NULL;

Have you looked at NWind yet?
 
Dear Pietlinden,

Many thanks for your prompt reply. I have'nt seen NWind as yet. I will see it
if you recommend this.

Best regards,

isons
 
Dear Pietlinden,

I made a update query but somehow it could'nt work for me.

I selected field "Vendor" and in criteria field, i past expression but it
gives me error "The expression you entered contains invalid syntax".

I am novice and need help.

Best regards,

Isons
 
Back
Top