Parameter query with multiple criteria

[AndeanWayne]

I have a parameter query where I have paramers for the fields: completion date between two dates, State, County and Buyer Number. Everything works great. But, I want to be able to either select a buyer Number or have the query show results for ALL buyers. I tried {Enter Buyer Number] OR Like [Enter Buyer Number] Is Null. Doing this gives me all the records in the query. It ignores all the other parameters. Can I do what I want either choose a Buyer Number or choose ALL buyers but the other parameter criteria take effect?

 

[John Big Booty]

The Sample here might give you same inspiration.

 

[Brianwarnock]

Drop the Like
[Enter Buyer Number] or [Enter Buyer Number] Is Null

And yes you can use this either way with the other parameters

Brian