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, Street1 and Street2 are not working properly. Well, Street1 is, but Street2 isn’t! The expression =[Street1] works, but the expression =[Street2] produces an error. The error is the insanely useless: #Error

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.