I think I am just missing something on this one so some help would be great. I am using Access XP and and '03 to run some queries off of an imported SQL table. I have two combo boxes that set my low and high limits for the query. I am isung the IIF, And statement to pull what the combo boxes define as the range.
Criteria: >=IIF([Forms]![Form1]![cboBoxLowValue] is null, [Fieldxyz],[Forms]![Form1]![cboBoxLowValue]) And <=IIF([Forms]![Form1]![cboBoxHighValue] is null, [Fieldxyz], [Forms]![Form1]![cboBoxHighValue])
When I run the query with the boxes empty it returns everything but the null values in my table.
if I simplify the criteria to just pull everything from the field without using the combo boxes IE: [Fieldxyz] - it still only pulls the non null values.
If I change the query again to pull only null values IE: is null - then it pulls only the null values.