Mike, if you are still stuck on this, would it be possible to use a Yes/No
field to flag the records for deletion? That's easy to do with an Update
query, and then the delete query is just:
DELETE FROM MyTable WHERE (IsPicked = True);
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Mike Wiseley" <mi**********@gte.net> wrote in message
news:Z4****************@nwrddc02.gnilink.net...
I tried the following variation of your theme:
Delete * From Table1 Where Table1.[Departure Point] like
(SELECT Distinct cTable1.[Departure Point] FROM cTable1 inner join Table1
on cTable1.[Departure Point] = Table1.[Departure point]);
Which was an attempt to delete multiple records from Table1 based on a
match against cTable1.
Access says "at most, one record can be returned from this subquery".
"tom" <to*@nuws.com> wrote in message
news:c1**************************@posting.google.c om... I believe Access also lets you specify which table in your FROM clause
to delete from, like so (The "I.*" part):
DELETE I.*
FROM tblInvoice as I
INNER JOIN tblInvoiceDetail as D
On I.InvoiceID = D.InvoiceID
WHERE D.InvoiceDetailID = 9;
-td
Try a subquery in the WHERE clause, e.g.:
DELETE FROM tblInvoice
WHERE tblInvoice.InvoiceID =
(SELECT InvoiceID FROM tblInvoiceDetail WHERE
tblInvoiceDetail.InvoiceDetailID = 9);