Update query?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Good afternoon. This question may have been answered, and I have not
searched for the right criteria in access monster to find it. If so, I
apologize for the repetition.

I need to update a field in several thousand records. There are two fields
involved: LCS number, and CLD number. The information we have is an account
number (LCS Number). The new values (CLD Number) are from an external source,
and we need to match these two numbers up. We have been given a spread***
with the information, and I need to add in the CLD number relative to each
LCS number.

For example:

LCS # CLD #
FM41 10001
GX22 10002
MT53 10003

Ideally, I would like to instruct access to find the LCS# and then input the
related CLD# in the CLD# field. And do this for all 2000+ records at once.

Any assistance is appreciated.

Thank you.

Nathan


--
Message posted via http://www.accessmonster.com
.

Quantcast