How do I replace a field value?

30 pts.
Tags:
How do I replace field values from other values in the same field?
I have a filed value that need to be replaced with a value from the same field based on another value in the table. Let's call the field "cost" in the table 'Location". The unique field is "item". In this case , an item exists in multiple locations, field name 'loc'. In each location, a unique item may have a different cost in each location. I need to replace the cost value in tertiary locations from the cost value in the primary location. I have no problem writing a script to replace all values in any given field, but I'm having trouble crafting a script for this process.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • JennyMack
    Hi there, Could you please specify what program you're using? Thanks, Jenny Community Manager
    4,280 pointsBadges:
    report
  • Jmconyer
    The application is Macola ES. The database lives on a server running SQL 2000.
    30 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following