By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,777 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

Help needed with Access 2003

P: 16
Hi I am using MS access query my problem is that I have a coloumn called Measure and one called MO.Where data is equal to "ABC" in MO column I need the data "ABC" to overwright the value in the Measure column. I think its a udpdate query but not sure how to use it. Hope this makes scense

Dave
Sep 5 '07 #1
Share this Question
Share on Google+
5 Replies


Scott Price
Expert 100+
P: 1,384
Hi I am using MS access query my problem is that I have a coloumn called Measure and one called MO.Where data is equal to "ABC" in MO column I need the data "ABC" to overwright the value in the Measure column. I think its a udpdate query but not sure how to use it. Hope this makes scense

Dave
Well, we can help with how to do that, but first of all, why do you want to store duplicate values in your table?

Regards,
Scott
Sep 5 '07 #2

P: 16
Well, we can help with how to do that, but first of all, why do you want to store duplicate values in your table?

Regards,
Scott
Hi Scott I need to compile a graph of the data.
In the measure column i have 5 or 6 differant measures one of the measures is {MO Other} where in the MO EX column if the column data is {Bank Alliance}
in need to change {MO Other} to Read {Bank Alliance} The MO EX column has just got an extra break down on the MEASURE COLUMN
Sep 5 '07 #3

Scott Price
Expert 100+
P: 1,384
Well, the general syntax of an update query is:
Expand|Select|Wrap|Line Numbers
  1. UPDATE [NameOfTable]
  2. SET [ColumnName] = [Value], [ColumnTwo] = [Value]
  3. WHERE [UpdateCriteria]
So you'll likely need to write something like this:

Expand|Select|Wrap|Line Numbers
  1. UPDATE tblX
  2. SET Measure = MO
  3. WHERE MO = "ABC"
When working with queries that change values in your table, you need to test the query completely on TEST data first!! :-) Make a copy of the real table with real data, and work on the copy until you get all the bugs worked out of your update query.

Regards,
Scott
Sep 5 '07 #4

P: 16
Well, the general syntax of an update query is:
Expand|Select|Wrap|Line Numbers
  1. UPDATE [NameOfTable]
  2. SET [ColumnName] = [Value], [ColumnTwo] = [Value]
  3. WHERE [UpdateCriteria]
So you'll likely need to write something like this:

Expand|Select|Wrap|Line Numbers
  1. UPDATE tblX
  2. SET Measure = MO
  3. WHERE MO = "ABC"
When working with queries that change values in your table, you need to test the query completely on TEST data first!! :-) Make a copy of the real table with real data, and work on the copy until you get all the bugs worked out of your update query.

Regards,
Scott
Thanks Scott works like a dream
Sep 6 '07 #5

Scott Price
Expert 100+
P: 1,384
Thanks Scott works like a dream
Glad it's working for you!

Regards,
Scott
Sep 6 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.