Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple fielt criteria (like ... or ) inputs for a rapport with query

Status
Not open for further replies.

vdzr

Technical User
Mar 6, 2003
42
DE
Witch is the solution for a rapport with one multiple input fielt that has to have a partial match for the different inputs?

e.g.
Fielt A input 1 = 10
Fielt A input 2 = 20
.
.
.
Result should be --> a query with the where instruction fielt A =(like '*10*' or like '*20*' or like ...)
 
... where (instruction like "*10*") or (instruction like "*20*") or ....
 
First I had a parameterfielt(automatic popup-input-box)in the query but sometimes a user has more than one input for one fielt and doesn't want to fill in the whole search string but only a partial mach.
Is there an excample of a parameter with different like expressions or can someone tell me how I put program-code behind a form with one independant fielt?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top