Multiple Parameter queries

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

Guest

I would like to create Form with Multiple Parameter Queries. The user will search for text with or/ and ,meaning that user may search for more than one parameter. eg. Search for ["Ram" and "India"] OR ["Ram" or "India"

Please advise me how to create command in queries.
 
Hi,



... WHERE ("," & param & "," ) LIKE ( "*," & FieldName & "'*" )



with param entered with data like "India,Ram" ( no space after the
coma).



If the table is large, may be preferable to create a temporary table, one
field, one record per word you look for, and make an inner join:


FORM myTable INNER JONI tempTable ON myTable.FieldName =
tempTable.ItsOnlyFieldNameHere



since the first formulation would result in a scan, while the last one will
use indexes (which is generally appropriate over a table scan at around 1000
records... make your own test to be sure).


Hoping it may help,
Vanderghast, Access MVP


murugesan said:
I would like to create Form with Multiple Parameter Queries. The user
Click to expand...
will search for text with or/ and ,meaning that user may search for more
than one parameter. eg. Search for ["Ram" and "India"] OR ["Ram" or
"India"]
 
Back
Top