DELETE statement

Originally Posted by Carcus

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]))

Originally Posted by Carcus

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]))

Originally Posted by abolos

The sql statement must be like: Delete * from tblnameage where stAge between 1 and 20

Originally Posted by JKing

I don't believe you can delete records from a query. DELETE statements are usually placed on a table. Though you may have misworded this or I've misunderstood but is [Employees Payslip to Home Address] a saved query? If so what is the table you're trying to DELETE records from? OR do you just want to filter your query so that it does not show records where [FROM] = [TO].

Originally Posted by missinglinq

You have inadvertently posted your question in the Access Articles Section! I have moved it to the Access Forum.

Welcome to TheScripts!

Linq ;0)>