Hi,
I would like to perform Vlookup in access.
Eg. I have two Tables
Code table
Code --- No
{ ------- 0
} ------- 1
A ------- 2
B ------- 3
C ------- 4
D ------- 5
( I have used this (----------) for clear understanding)
Sale Table
SaleCode SaleNo
}
A
A
{
{
B
C
B
I would like to Vlookup SaleCode in Code and get respective Record i.e No. in SaleNo.
Can any one help me perform this task