Input one criteria to search in 5 fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear Friends,

I have a table containing 5 fields for marking customers' address, i.e.
Address line 1
Address line 2
Address line 3
Address line 4
Address line 4
The users input the same street name in different address line. For
example, if I want to find all the customers living in Queen Street, I need
to input once and copy and paste the first input to the subsequent input box
in order to search all customers living in Queen Street.

Thanks

Fanny
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Input one criteria for searching 5 fields containing the same data 5
Split data in field on character return 0
In search of a new Obelisk 6
Merge address in XL to Word letter template 1
Input box and filters 3
Column mailing list needs to be converted to rows 2
Sort a column in Excel 2007 2
Transpose Based on Criteria 9

Back
Top