Recent content by AccessUser21

I had the best luck with gblack's post. Below is the code I used, worked like a charm! StNumber: IIf(Int(IIf(IsNumeric(Left(Trim([Address]),2))=True,Left(Trim([Address]),2),0))>0,NZ(Left([Address],InStr([address]," ")-1),0),"Doesn't matter") AddressNames: IIf([StNumber]="Doesn't...