Ensure that the field is populated on the record:
  1. Go to the record that has the blank value
  2. View the field represented in the query to see if it is populated
  3. If the field is blank we can do either of the following:
    • Leave it blank (if we do not have the correct data to add, this will leave the field blank for this record in the query)
    • Populate the field with the correct data and re-run the query to see the result