Help needed with Access 2003

[Davidsm]

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

[Scott Price]

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

[Davidsm]

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

[Scott Price]

Well, the general syntax of an update query is:

UPDATE [NameOfTable]
SET [ColumnName] = [Value], [ColumnTwo] = [Value]
WHERE [UpdateCriteria]

So you'll likely need to write something like this:

UPDATE tblX
SET Measure = MO
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

[Davidsm]

Well, the general syntax of an update query is:

UPDATE [NameOfTable]
SET [ColumnName] = [Value], [ColumnTwo] = [Value]
WHERE [UpdateCriteria]

So you'll likely need to write something like this:

UPDATE tblX
SET Measure = MO
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

[Scott Price]

Thanks Scott works like a dream

Glad it's working for you!

Regards,
Scott