New project in Access that I am trying to get a list of all records that a particular field IsNull, blank or Empty.
The query is based upon table tblCOA. That table (tblCOA) has a field that is linked to another table tblAcctntCOA. I am trying to get a list of just the records in tblCOA that have not had a value selected.
(Lookup Field to tblAcctntCOA)
In a query of tblCOA I selected AcctntGLAcct# an used the Criteria:
However I don't get any results. I know that currently all of the records in tblCOA except 2 have a value.