I am just trying to muddle my way through MS Query and while I think I've figured out what I need, I'm having trouble with one thing...

I have Parameters set looking at 4 different cells, which change based on another cell's contents. I would like to have the query pull data based on these 4 cells, and ignore them if they are blank. There will always be data in 2 of the cells, but only sometimes in 3 and 4 of them.

Here is my code:

SELECT `Data$`.Div, `Data$`.`Sold to cust`, `Data$`.Name, `Data$`.`INCENTIVE SALES BASE`, `Data$`.`Sales person`
FROM `Data$` `Data$`
WHERE (`Data$`.`Sales person`=?) OR (`Data$`.`Sales person`=?) OR (`Data$`.`Sales person`=?) OR (`Data$`.`Sales person`=?)
Hope this makes sense...