D
Darren Spooner
I have a search form with 3 fields on it, I also have a query that has the
same fields as the form and in the Criteria section I put LIKE "*" &
[forms]![formName]1[textField] & "*" I each field. I have one field(field2)
that in the table is NULL, so when I enter data to the first field and
nothing in the other 2 fields it will only get the data that field2 is NOT
NULL.
how do I get the records that may have a NULL value in field2
same fields as the form and in the Criteria section I put LIKE "*" &
[forms]![formName]1[textField] & "*" I each field. I have one field(field2)
that in the table is NULL, so when I enter data to the first field and
nothing in the other 2 fields it will only get the data that field2 is NOT
NULL.
how do I get the records that may have a NULL value in field2