Code:strSQL = "DELETE * FROM hld22CGinRangeSelected WHERE (tblCase.[IncomeAAP?] OR tblCase.[IncomeChildSupport?] OR tblCase[IncomeFosterCare?]) NOT IN (" & strIncomeSource & ")"
For some reason, I am getting a syntax error so can't test it.
If those field names are reflecting the original source tables and they have those names to disambiguate fields which would otherwise have the same name, they are referred to not as:
Code:
tblCase.[IncomeChildSupport?]
but as
Code:
[tblCase.IncomeChildSupport?]
BtW It is a terrible idea to put special characters in any object name.
You can't OR a bunch of fieldnames and apply them to an IN clause. Each field must be separately dealt with. OR only applies to values. CJ_London hinted at this in the first reply.