Can anybody tell me what I an doing wrong in my IIf statement.
OTD 1: IIf([1st OTD Colour Points]=[2nd OTD Colour Points],2,IIf([1st OTD Colour Points]=[2nd OTD Colour Points] and [2nd OTD Colour Points]=[3rd OTD Colour Points],3,IIf([1st OTD Colour Points]=[2nd OTD Colour Points] And [2nd OTD...