AnsweredAssumed Answered

AND statement in formula

Question asked by NigelBurton on May 28, 2015
Latest reply on May 29, 2015 by philmodjunk


AND statement in formula


I am trying to calculate a value in a field in a table that compares three items in the table with three items in another table and if all three match up then they return a value that is stored in a field in the other table.

The formula I am using is 

If(Vessel_#_1 = Vessel Schedule::Vessel  and  Vessel_Voyage_#_1 = Vessel Schedule::Voyage_# and Load_Port = Vessel Schedule::Load_Port;Vessel Schedule::Load_Port_ETD)

It should return a date value into the field and the calculation is unstored.

Can someone please advise why it is not working and a better way of achieving my desired out come.