Sunday, July 1, 2018

How to query for null values in a form

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') 

No comments:

Post a Comment