I have a field called "Part Number".
I have a form where someone can put in a part number and it can show all the results that match or where they can put in an * and find all results, except the results with * exclude Null, which is a problem.
What I want is for an entry of * to include all things INCLUDING Null values, but anything besides * to include only matches and exclude Null Values.
I had a criterion that looked like this: Like [forms]![Search].[FilterValue1]
I tried adding a second criterion that read like this: IIf([forms]![Search].[FilterValue1]<>"*",[forms]![Search].[Filtervalue1],Null) but this didn't work.
Any ideas on how I might accomplish this? Thanks!