My company is converting the account codes and I am verifying that each code has been assigned a new one.
I was given 2 tables: 1 with current account codes, and the other provides the new code by range of current account codes. For example, if the current code is 1225, the conversion table would assign a new code K001 for current codes ranging between 1200 and 1299. What function do I use in the current code table, so that the formula assigns the new code to each current code?
Microsoft Access 2007
October 18, 2010 3:16 PM
October 18, 2010 3:21 PM