iif statement where true I what all records

[Newby]

In a query I have a nested iif statements where if "All" is selected I want all records. If "Income" or "Expense" is selected I want only those records. If I select "Income" or "Expense", I get the desired result, and if I select "All", I get a null result. Below is my formula.



If([forms].[sourcesSelect].[Cbx_IncExp]="All","*",IIf([forms].[sourcesSelect].[Cbx_IncExp]="Income","Income",IIf([forms].[sourcesSelect].[Cbx_IncExp]="Expense","")))

[pbaldy]

Personally I don't like that method. I'd have the combo box return Null for the "All" selection, and use this:

http://theaccessweb.com/queries/qry0001.htm