Missing data
1 TopicSet up query to find missing data in multiple fields
Hey Microsoft Community, I am trying to set up a query that will find records that are missing data. For example, I have a main form where users will enter biographical data, but they may be missing the birthday, the last name, and the phone number. The idea is that this query will help us identify the records which are missing data and allow us to then go back and enter this data in when we find it. How would I set up the query to catch the records with any missing data? I first tried to place "Is Null" (not in quotes) in the OR section of the query, and it worked with only one field being tested, but as I added more fields it could not find a record with missing data. As always thank you for taking the time to read this and help with this issue. I look forward to your response. Thanks, EbSolved5.7KViews0likes4Comments