I have the query depending on data from a form.
ie:
1. field on form = strSuffix
criteria in query: strssuffix = [forms]![myform]![strsuffix]
2. field on form = street
criteria in query: street = [forms]![myform]![street]
There are null values in some of the street data and I
want the query to pull street if it matches the street on
the form or if it is null. I have tried putting = null
on the second line of the criteria(underneath the criteria which is = [forms]![myform]![street].
THe nulls are killing the query. How can null be handles for different situations?
ie:
1. field on form = strSuffix
criteria in query: strssuffix = [forms]![myform]![strsuffix]
2. field on form = street
criteria in query: street = [forms]![myform]![street]
There are null values in some of the street data and I
want the query to pull street if it matches the street on
the form or if it is null. I have tried putting = null
on the second line of the criteria(underneath the criteria which is = [forms]![myform]![street].
THe nulls are killing the query. How can null be handles for different situations?
