I have a customer table with 3 different phone number fields.  I need to do a parameter query and enter a phone number once and have access search all 3 phone number fields for a match.  Possible?

---

Reply from Richard Rost:

Very good question. Yes, it's possible, but it's a little beyond what I showed in today's class. You can either use a query-level parameter or an unbound form with a search field on it. I will cover both of these in the Expert classes, but this tutorial will show you how to set up the search form. You would just use the same text box as your criteria for each of the 3 different forms with an OR condition.