Recent content by cgavin

Thanks for your help Bob and John, this is the one that worked for me. Much appreciated, Colm PS Sorry about the delay in replying

Hi All, I am doing an Access report and for one of the fields I am required to do a "fairly" complicated formula whose results change depending on other values stored in other fields on the form. The Excel formula is this: =IF(A7="Completed",IF(OR(K7="Cost Avoidance vs...