Hi
I hope someone can help me with this one. I am writing a DELETE statement to run on a query I have set up called [Employees Paylsip to Home Address]. I'm trying to delete all records with a [From] and [To] date that are matching.
I'm currently getting an error message saying "The expression you entered contains invalid syntax. You may have entered an operand without an operator." - I don't even know what this last line of the message means.
Here is my incorrect SQL- (this is most likely totally all over the place as I'm flying blind here!!).
Expr1: ([DELETE]*FROM([Employees Payslip to Home Address]WHERE([From]=[To]))
I hope someone can help me with this one. I am writing a DELETE statement to run on a query I have set up called [Employees Paylsip to Home Address]. I'm trying to delete all records with a [From] and [To] date that are matching.
I'm currently getting an error message saying "The expression you entered contains invalid syntax. You may have entered an operand without an operator." - I don't even know what this last line of the message means.
Here is my incorrect SQL- (this is most likely totally all over the place as I'm flying blind here!!).
Expr1: ([DELETE]*FROM([Employees Payslip to Home Address]WHERE([From]=[To]))
Comment