Excel Query to Exclude a Condition but if left blank would return all Condition's

[DennisYoung]

I am trying to Add a Query to my table to Exclude a Condition that would be set by a Parameter setting pointing to a cell.

I know how to add the Condition field to the Query (SH2.jpg) but I do not know what to use as the value so the parameter would look at the cell and exclude the value in the cell and return all other values to include blank values and if the value is left blank to return all values.

I have the reference cell set up (SH4.jpg)

I have tried <>"*", <>[], <>?, <>[?] and other combinations but none have worked

Any help would be appreciated.

 

[DennisYoung]

Never had a question go unanswered before.

I did figure out how to do this though.

In the MSQuery I added Criteria field of Condition then in the value put in <>[Parameter4} then under or I put is Null then added a second [Yard#] and Between [SD] and [ED]

And it made a parameter for me that I pointed to the reference cell I wanted to exclude

And on a refresh all worked perfectly

I added a total of 5 Parameter fields like this (see screenshot SH5.jpg) and pointed those Paramters (see screen shot SH6.jpg) to separate reference fields (see screen shot SH7.jpg)

And I can exclude one or multiple Conditions this way