IIf(IsNull(RF_DCSGCoverage!Region),RD_SW... In ("TK","HK"),"FE",IIf(RF_DCSGCoverage!Reg...
RF_DCSGCoverage = NAME OF THE TABLE
RD_SWUB_ALL = NAME OF THE TABLE
REGION = FIELD OF THE TABLE
TK=TOKYO
HK=HONGKONG
FE=FAREAST
LN=LONDON
EU=EUROPE
NA=NORTHAMERA
Please Please Please advise.
Thank you sooooooooooooooooooooo much for your help
Tags: