using form input query

  • Thread starter Thread starter toby
  • Start date Start date
T

toby

i 've a book list union database (which link 2 excel db sources)
with column A, B, C, D, .........
such that :
column
A B C D E
... be ... .. ...
... be .. ... ...
... ce ... .. . ...
... de .. ... ...

is it possible to make an query with input box, so that i can enter more
than one criteria to select the type of row data i want ?! let's say, i
enter (be, & ce & de), then it can select the rows of data with be, ce or
de in column B.
Thanks in advance

Toby W.
 
Hi,



WHERE ( "," & parameter & "," ) LIKE ("*," & B & ",*")



with parameter something like:

be,ce,de

without space after the coma.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top