Solved

access update query

Posted on 2012-03-15
3
236 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
  • 2
3 Comments
 
LVL 13

Expert Comment

by:lee555J5
Comment Utility
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
Comment Utility
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
Comment Utility
hit on it by chance!
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

743 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now