Hello there,
I am facing a issue filtering all records in query table when I select "All" from a combo box. Following image will explain all..
Now I have also tried with expression in AssetCategory field: IIf( Forms![Employee-Report]![cboAssetCat1] ="All", "*", Forms![Employee-Report]![cboAssetCat1])
which returns any category that I select from the combo box but If I select "All" it returns 0 records
As I'm not a Programmer and creating a database with my minimal knowledge, seeking your expert advice or any other way to do it.
Thanks
Regards
Leo