The SQL of the Delete query would look like
DELETE
FROM LargeTable
WHERE LargeTable.DateField in
(SELECT DateField FROM SmallTable)
IF you can only use the QBE (Design View - query grid) then
-- Open a new query
-- Select the Large Table
-- Select the DateField
-- TYPE in the criteria under the date field - something like:
IN (SELECT [Name of Date Field] FROM [Small table])
-- Select Query: Delete Query from the menu
-- Select View: Datasheet view from the menu to SEE which records will be
deleted
-- Select View: Design view to switch back
-- IF you are happy with the proposed deletions then Select Query: Run from
the menu
WARNING: Backup your data first. If this doesn't do what you expect the
only way to recover is to
--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
