Delete Records

  • Thread starter Thread starter diane walker
  • Start date Start date
D

diane walker

How do I setup a query to delete all the records from 1/1/2002 - 12/31/2002?

Thanks.
 
In the Criteria: row for the column containing your date field, insert the
following:

Between #1/1/2002# and #12/31/2002#
 
Delete * FROM Table WHERE SomeField Between #1/1/2002# and #12/31/2002#

If you are doing this in the grid view. Then set up a Select Query to select the
records and then change it to a delete query.
 
Thank you very much for your quick response and information.

Your instructions worked. I looked in Help and Microsoft web site and could
not find any information.

Thanks again.
 
Thank you very much for your quick response and information.

Your instructions worked. I checked the Help section and Microsoft web site
and could not find any information. Thanks again.
 
Back
Top