View Full Version : Text Boxes and Logical agurments


Luddite Lad
08-28-2005, 03:21 AM
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
08-28-2005, 04:39 AM
=Iif([ETA] > Date(), "Vessel not arrived" , "Vessel arrived")

Luddite Lad
08-29-2005, 04:41 PM
Just what I was looking for, thanks for the pointer :)