[AccessD] Delete record via query with another query

Hi Annie

Yes, you can do something like

  Delete * From sometable
  Where ID In (Select SomeID From anothertable Where ...)

/gustav


> Here my problem.  I want to be able to delete record from a table using the
> result of a query.   Is that possible?  I was able to do it running code and
> a recordset... but, to increase the speed, I would like to so it with a
> query.