C
Cheint1
I have a complex query (qryZP57errors) that identifies
possible data entry errors from a single table (tblZP57).
The primary field in tblZP57 is 'SSN'. I want my users be
able to update another table (tblNOSHOWZP57) with the
SSN's that are not to be shown on my error report
(rptZP57) -- which is based off of qryZP57errors.
My problem is...how can I get the report to SHOW all of
the SSN's who are on the qryZP57errors query, BUT NOT IN
the tblNOSHOWZP57?
Basically, I need a way to check tblNOSHOWZP57 first. If
the SSN is in here, I don't want the SSN showing up in my
qryZP57errors. If the SSN is NOT in there, I want the SSN
to show up in qryZP57errors.
Thanks in advance,
Cheint1
possible data entry errors from a single table (tblZP57).
The primary field in tblZP57 is 'SSN'. I want my users be
able to update another table (tblNOSHOWZP57) with the
SSN's that are not to be shown on my error report
(rptZP57) -- which is based off of qryZP57errors.
My problem is...how can I get the report to SHOW all of
the SSN's who are on the qryZP57errors query, BUT NOT IN
the tblNOSHOWZP57?
Basically, I need a way to check tblNOSHOWZP57 first. If
the SSN is in here, I don't want the SSN showing up in my
qryZP57errors. If the SSN is NOT in there, I want the SSN
to show up in qryZP57errors.
Thanks in advance,
Cheint1