I have the same question as June7...why two fields? This strongly suggests that your db is not normalized.
I'm running with a dcount right now but it has to be word for word, and in the exact same phrase, to match.
The best way to insure that data is entered, using a specific format, is to provide all possible inputs via a Combobox. If there are sometimes situations which are unusual, you could have one Combobox selection that simply says 'Other,' then have a Textbox to enter the non-standard response.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007