flexible search query

[marci1234]

hi i have a database with a table with different fields country, address, name etc
i need to buid a query where i can select as a criteria each time either
criteria from one field, two three or more.
anyone can halp me? maybe i need to use modules?

actually i need to build a serach form with the field like the ones in the
table and then be able to search in the table according with the criteria
that will be put in the field, criteria will change for each search,
thanks for your help

 

[PHV]

Do a keyword search in the Access fora for qbf

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[dhookom]

There is a complete Query By Form "applet" at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

It allows users to select any field and set criteria.

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]