Solved

access update query

Posted on 2012-03-15
3
240 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
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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

This article will show you how to use shortcut menus in the Access run-time environment.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
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.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

840 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