Evidence has come to light that suggest that Microsoft Access was a creation of the devil. Designed to destroy the sanity of us mere mortals.
Two identical fields,
Street2 are not working properly. Well,
Street1 is, but
Street2 isn’t! The expression
=[Street1] works, but the
=[Street2] produces an error. The error is the insanely useless:
Stupid Access. Back to the fires of hell I condemn thee.
UPDATE (15th August 2006): Now I’ve noted that I can’t have more than 9 “OR” statements in a query in design view. The whole point of design view is to make those sort of horrible queries easy!!
UPDATE (Just after rant): Ok, so it is possible, but not in the nice way I expected.