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.