Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

How use an update query to make all prices 0.0000

I have a table that has a price_ea field and in this table some of the records have a value in this field.  But I want to update all of the prices to 0.  How can I do this with an update query?

--Steve
0
SteveL13
Asked:
SteveL13
1 Solution
 
Dale FyeCommented:
UPDATE yourTableName
SET [Price_ea] = 0

But this will set ALL of the prices to 0.  If you only want to set those that don't already have a value (where the value is NULL), then you would use:

UPDATE yourTableName
SET [Price_ea] = 0
WHERE [Price_ea] IS NULL
0
 
mbizupCommented:
Update yourtable
Set yourfield =0
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now