July 14, 200421 yr I've attached a file. I am trying to compare two text fields which, as far as I can tell are identical. I even ran Trim() through both fields. But the following number calculation says they are not equal. Case(Company = Contact; 1) I even tried: Case(Company Contact; "Not Equal") and it says 'Not Equal' on every one. I know I'm very tired but, for the life of me, I can't see why it doesn't produce 1 on 98% of them. It is driving me nuts. Any ideas please? LaRetta Strange.zip
July 14, 200421 yr Author Good grief!! I must be going blind - okay actually I am. It must be time to go do some basket-weaving or paper-doll cutouts. Thanks JT. Sometimes the funniest things can trip us up.
Create an account or sign in to comment