If...else statement

[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!

 

[Guest]

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

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

David S.
DataOverTheWeb.com

 

[Tim Ferguson]

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