Replacing all of the data in a table

[Amyk]

I have been given the task of fixing a database that someone else designed and I am not too familiar with the code they wrote, so I was wondering if there was any way to do this automatically in access: I have a table that lists about 5 different numbers for each record that correspond to a word in a different table.  What I want to do is replace all of the numbers in the table with their corresponding alpha-value.  All of the realtionships are set up, and so I wanted to see if there was an easy way to convert the data, or if I have to do it by hand.  Thanks!!!

 

[Lightning]

Use an update query to do this.&nbsp;&nbsp;Check out the topic<br>&quot;Change records as a group using an update query&quot; in the on-line help.<br><br>Lightning