Question:

What is this access logic saying please?

by  |  earlier

0 LIKES UnLike

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:

   Report

1 ANSWERS


  1. It is basically a seried of logical checks, directing the program to take certain actions based on the value in certain fields in the table.

    If the Region field in the RF_DCSGCoverage table is Null, then use the value of the next expression (in this cae, it sounds like a field in the RD_SWUB table)

    I can't really comment on the rest, as I can't see it. But basically, that's what is happening.

Question Stats

Latest activity: earlier.
This question has 1 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.