Text Boxes and Logical agurments

[Luddite Lad]

Is it possible to use a logical test to show different text in a text box on a report? If so what is the correct syntax?

for example;

if ETA > date then "Vessel not arrived" else "Vessel arrived"

 

[Rich]

=Iif([ETA] > Date(), "Vessel not arrived" , "Vessel arrived")

 

[Luddite Lad]

Just what I was looking for, thanks for the pointer