Mapping from Table

[Daniel]

I tried to make a mapping.

I have one table with diffrent account and with a specified number. and now
the numbers are new. so I have an other table with the old numbers in the
first column and with the new numbers in the second column. and now I want to
make a query table with the account in the first, which stay as before and a
column with the new numbers.
it has to be similar like in excel with vlookup. it must go to the table,
look the old number and outputs the new number.

I hope it's not to difficult to understand with my poo english....

 

[Clifford Bass via AccessMonster.com]

HI Daniel,

Try something like this, substituting you table and column names as
necessary:

select B.OldAccountNumber, B.NewAccountNumber, A.AccountName, <other fields>
from tblAccounts as A inner join tblOldToNewAccounts as B
on B.OldAccountNumber = A.AccountNumber;

Please note, that unlike Excel, Access/SQL does not care about column
number, only column name. If that is not clear, please post the relavant
table structures.

Clifford Bass