Select All from Jump Menu

[RFH Reseller: s80wkr]

I am using three jump menus to search seperate fields in a db
The 3 variables are: -

var_dept - Department
var_cate - Category
var_haz - Hazzard

I want to be able to select either all three or any combination of the three variables

I have tried setting the variables to % and * in the jump menu but it does not bring back any records

[RFH Reseller: s80wkr]

Sorted now

I have used LIKE and used % in my statement

[RFH Reseller: nick]

Sorted now

I have used LIKE and used % in my statement

you could also use

      WHERE table.myfield IN ( 'list', 'of' , 'possibilities' )

*if I have understood your problem correctly.