I have a report that shows the salesman, manager, purchaser, ans sourcing person for each account. I want to setup the report so that each department can run the report against their name in a drop down list. This works fine if I only have one drop down list such as salesmen. Once I had another list such as manger, I have to pick one from each list before the report will run. I checked allow NULL and allow blank on the parameters. Is it possible to have 5 paramters and only fill in one of them and still have the report run against that parameter. I think it may have something to do with the select statement.

On your where clause use the like statement and supply the wildcard % for the parameters not supplied.

Tim Coggins
Lexington Home Brands
Voice - (336)-474-5423
Email - tcoggins@lexington.com