Choice query problam

[Lyubomyr]

Hi!
I need to form query which should search for the customers thu the base. The customer table contains many fields such as company name, contact person, location and others. All i need it to find if it is possible to have one parametrized query and use as if i had several queries.
Example
find the customer by the company name
fine the customer by the company name and contact person
find the customer by all fields

Thank you

 

[dhookom]

You could create a form with a text box "Forms!frmSearch!txtFind". Then you query can have a where clause like:

Where Instr(CompanyName & ContactPerson & City & Address, Forms!frmSearch!txtFind)>0

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]