Query criteria - Help using Like *

[razor5]

is there a way to place the Like "*" in a query criteria field using the iif() function?

I have a combo box that has different materials.
and a ALL material, when I select ALL, I would like
for the query to display all materials.

 

[paron]

You might be able to modify the approach in

support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q98660&

by using your fieldname = "All" in the iif() criterion instead of IsNull.


Ron