Creating Multiple Criteria Query

[mercwonder007]

I have a table that consists of address street names. I would like to create a query that allows me to type in multiple street names or possibly choose from a list and have it narrow it down to a report. I don't want a parameter query, I would like to to create a form that has a large field to type in multiple values or have 3 to 4 drop down boxes that then narrow the criteria to what I have chosen. Is there an easy way of doing this. Thank you for your help.

 

[RobReid]

If you decide to use a large field you could use the criteria line
Like * & forms!formname!fieldname & *
this will match any set of characters you enter into the field.

If you use multiple dropdowns then you could simply use
=forms!formname!combo1 and then use the OR option in the criteria fields. This will allow you to use up to 9 combo boxes.

Hope this helps.

Robreid