If...else statement

  • Thread starter Thread starter Quest
  • Start date Start date
Q

Quest

How do I use the If...else statement?? I basically want
to retrieve records using a query and if that particular
field in the record is empty than add to those empty
fields details. If not return a messaged saying that the
record is already filled.

For example: check record to see if tool issued has been
returned or not.

Thanks!
 
In the top line "field line" of the query try this;

CheckIT:iif(isnull([field]=true,[details],"Rec Filled"))

David S.
DataOverTheWeb.com
 
In the top line "field line" of the query try this;

CheckIT:iif(isnull([field]=true,[details],"Rec Filled"))

Brackets:

CheckIT: IIf(IsNull([Field]), "Something else", "Already filled")


HTH

Tim F
 
Back
Top