I have a query that the iif statement in the criteria of column "SalesRepID" will not acknowledge the true part of the iif statement of "Is Not Null". this only happens when i use "Is Not Null" and any operator like(>,<,<>,null,Like"*") in the iif statement.

I want the query to return all values if the saleid field from form!menu_reports is null.

IIf(isnull([forms]![menu_reports]![saleid]),is not null,[forms]![menu_reports]![saleid])

If I put a value there it will return the records for that value, ex:14


Thanks for any help you can offer.