Hi All,
I am pretty new to Access. I am using Access 2010.
I am trying to run a query to filter data based on combobox. It's seems to be drawing blank without pulling any results.
Detailed explanation:
I have a table with lot's of column and i need to filter this table based on a value selected by user. Only three values can be selected by a user and i am using this to filter one of the columns using IFF function.
IIf([Forms]![Test_Form]![Combo97]="Only Pass Results","L",IIf([Forms]![Test_Form]![Combo97]="Only Fail Results","P","*"))
- It seems to be drawing blank.
- Secondly if i just use one IFF statement, "*" doesn't seem to work.
Any help appreciated.
Thanks