How to query for null values in a form
- press Enter Query
- navigte to your field
- type "# IS NULL" in the field (without quotes)
- press Execute Query
it does not guarantee to work
essentially anything after # is added to SQL query for
your field, so you could do:
# IN ('A','B')
- navigte to your field
- type "# IS NULL" in the field (without quotes)
- press Execute Query
it does not guarantee to work
essentially anything after # is added to SQL query for
your field, so you could do:
# IN ('A','B')
No comments:
Post a Comment