Solved

access update query

Posted on 2012-03-15
3
243 Views
Last Modified: 2012-03-20
update query please

i have a column in dbse which contains some numbers say 1 22, 30 38

they may go up to 100 in due course or more
i want to devise a query that will change a group of them

say all the 10 s in the column to 12 or some other number of operators choice

help ppl
0
Comment
Question by:topUKlawyer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 13

Expert Comment

by:lee555J5
ID: 37726728
What are those numbers -- "1 22, 30 38"?
Did you mean
1
22
30
38
etc.
?

If so, try this
UPDATE table_name
SET column_name = 12
WHERE column_name = 10;

Open in new window

Lee
0
 

Accepted Solution

by:
topUKlawyer earned 0 total points
ID: 37727181
many thanks i have resolved it myself with two sets of criteria [old number] and [new number]

which allows me to enter in a value for the updates as ans when we need them.
0
 

Author Closing Comment

by:topUKlawyer
ID: 37741266
hit on it by chance!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question