What is the difference between:
Like Left([Forms]![ProjectForm]![Details].[Form]![FireRating],4) & "*" and
Like nz(Left([Forms]![ProjectForm]![Details].[Form]![FireRating],4) & "*","*")
How would I get a different result
What I would like is:
Like [Forms]![ProjectForm]![Details].[Form]![FireRating] or isnull.
What I'm trying to acheive is, filter records by the exact content of the form field unless the field is empty (Is null and "") in which case show all the records.
You always can add separate field to your query equal to
Isnull([Forms]![ProjectForm]![Details].[Form]![FireRating])
with OR criteria True
to your main criteria