Filter Multiple Fields

[Guest]

I'm using Access 2000. I have a form with 25 fields. I need my end user to
be able to open the form and filter the output so that it searches all the
fields for whatever criteria they enter (e.g. search multiple fields). At
one point, I thought I had it covered because I created a query and added
("Like "*" & [Enter Key To Search (or leave blank for all)] & "*"") to the
Criteria line and then entered this same string for the "OR" lines under
several fields. Since I had to use a lower line for each field, it appeared
I ran out of lines. My problem with this option was it only has nine lines
so it appeared I could only search nine fields.

I have searched the forum and have tried several ideas, but so far I haven't
been successful. Any assistance would be greatly appreciated.

 

[John Vinson]

I'm using Access 2000. I have a form with 25 fields. I need my end user to
be able to open the form and filter the output so that it searches all the
fields for whatever criteria they enter (e.g. search multiple fields). At
one point, I thought I had it covered because I created a query and added
("Like "*" & [Enter Key To Search (or leave blank for all)] & "*"") to the
Criteria line and then entered this same string for the "OR" lines under
several fields. Since I had to use a lower line for each field, it appeared
I ran out of lines. My problem with this option was it only has nine lines
so it appeared I could only search nine fields.

I have searched the forum and have tried several ideas, but so far I haven't
been successful. Any assistance would be greatly appreciated.

With 25 fields this query will get really unruly. You CAN do it - in
the query design grid, select all nine OR lines and click the Insert
menu item, and insert rows.

But I'd suggest that a much simpler solution, for you and the user, is
to use Filter by Form. Take a look at the toolbar when the form is
open, and select the Filter by Form option. It's designed for just
this purpose.

John W. Vinson[MVP]