Recent content by K2M

I am looking for a instr query that searches on two fields ([Field1] and [Field2]) where in between there is a 6 character text that could be anything. So basically it searches in a string for [Field1] + any six character string + [Field2] Test: IIf(InStr([Field1] & ?????? & [Field2]),1,0))...