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
 
Sorry, this should be a question to be located in Access query!!!! pls ignore
this one
 
You must log in or register to reply here.

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
Merge address in XL to Word letter template 1
In search of a new Obelisk 6
Input box and filters 3
Column mailing list needs to be converted to rows 2
Special characters 3
Sort a column in Excel 2007 2

Back
Top