Hello all,
What I'm trying to do sounds so easy but has proved painfully impossible for me so far.
I am trying to have a delete query remove all records from multiple tables, all of which a one-to-one relationship.
There is only a single criterion that has to be checked before deleting: find all records in a single table where the field is empty. The field in question can only hold numbers.
Would it be the "IsNull" function I should be using? What would the expression look like (in case I'm using the expression builder incorrectly)?
Thanks in advance,
Repeat3
What I'm trying to do sounds so easy but has proved painfully impossible for me so far.
I am trying to have a delete query remove all records from multiple tables, all of which a one-to-one relationship.
There is only a single criterion that has to be checked before deleting: find all records in a single table where the field is empty. The field in question can only hold numbers.
Would it be the "IsNull" function I should be using? What would the expression look like (in case I'm using the expression builder incorrectly)?
Thanks in advance,
Repeat3
Last edited: