Hi,
I am trying to write an iif statement in an access query if the date from the CATS is between the start and end date from TABLE return WKDate else nothing. Can you please help.
Sharon
CATS!:iif([CATS]![Date] >= [Table]![Start] and< =[Table]![end] [Table]![WK Date] )