Delete Query Criteria (1 Viewer)

[NearImpossible]

When trying to run the following delete query (Screen shot attached), I am getting "Specify the table containing the records you want to delete"

It is due to the Criteria entries and I don't know how to fix it.

Please advise

thank you

 

[June7]

Post the SQL statement, not just image of design.

It is not necessary to list table fields in DELETE action because the entire record is deleted.

DELETE FROM table WHERE some criteria here;

Perhaps you should do like:

DELETE FROM dbo_db_AddNewTicket WHERE TicketID IN (SELECT TicketID FROM Temp);

Why would TecnicianID be needed? Can each ticket have more than one technician associated? Don't see how if TicketID is primary key in main table.

 

[isladogs]

That should be:

DELETE [B][COLOR="DarkRed"]*[/COLOR][/B] FROM TableName WHERE some condition

OR if more than one table is involved in the query, something like:

DELETE [B][COLOR="DarkRed"]DISTINCTROW *[/COLOR][/B]  FROM TableName LEFT JOIN OtherTableName ON (TableName.FieldName =  OtherTableName.OtherFieldName WHERE some condition)

 

[June7]

Just as explicitly listing fields is not needed, neither is wildcard. Access query builder will throw it in if query object is saved (just as it will add bunches of unnecessary parens) but the action will run just fine without.

 

[NearImpossible]

Post the SQL statement, not just image of design.

It is not necessary to list table fields in DELETE action because the entire record is deleted.

DELETE FROM table WHERE some criteria here;

Perhaps you should do like:

DELETE FROM dbo_db_AddNewTicket WHERE TicketID IN (SELECT TicketID FROM Temp);

Why would TecnicianID be needed? Can each ticket have more than one technician associated? Don't see how if TicketID is primary key in main table.

DELETE FROM dbo_db_AddNewTicket WHERE TicketID IN (SELECT TicketID FROM Temp); worked like a charm, and I was using both columns in another query that I copied to make the delete query, but you are correct in stating that TechnicanID is not needed

 

[isladogs]

Just as explicitly listing fields is not needed, neither is wildcard. Access query builder will throw it in if query object is saved (just as it will add bunches of unnecessary parens) but the action will run just fine without.

I was assuming the delete query would be saved