Show multiple fields as one, for searching purposes.

[Benjamin Bolduc]

Hello everyone,

Im trying to set up a combobox on my Customer Contact Information form, where you can enter a phone/fax/cell/pager or any misc number, and it will bring up the appropriate customer.

Is it possible to make a query that will show the different phone number fields as one field?

Thank you so much for your help, and please let me know if I can clarify anything.

-Ben Bolduc

 

[Benjamin Bolduc]

Pat, I appreciate your personal attention to this.

I'm afraid Im still a bit of a novice when it comes to SQL progamming. I usually relay on the nice, friendly query building screen lol.

Where exactly do I put this code to make my Combobox work?

Thank you so much, I look forward to hearing from you.

-Ben Bolduc