Re: Delete record howto?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Rick Brandt (rickbrandt2_at_hotmail.com)
Date: 04/29/04 

Date: Wed, 28 Apr 2004 21:38:28 -0500

"Mike J" <anonymous@discussions.microsoft.com> wrote in message
news:5a9701c42d92$40553e60$a401280a@phx.gbl...
> I have a table that has an ID field and a Date field.
> There would be many records with the same ID in this table
> but all the dates for that ID are different. So, I wanna
> search for a record with an ID and a specific date and
> then delete it. I'm having trouble doing this; can
> someone show me how? Thanks.

If the date has no time component (actually a time of midnight) then it
would be something like...

DELETE * FROM YourTableName
WHERE ID = 123
AND DateField = #1/1/2004#

Relevant Pages

  • Re: Show previous month
    ... "Rick Brandt" wrote in message ... > DateField Between DateSerial, Month-1,1) ... > The above assumes that your date fields have no time component (all are ... > exactly midnight). ...
    (microsoft.public.access.reports)
  • Re: Show previous month
    ... > I like to show previous month on the report during current month, ... DateField Between DateSerial, Month-1,1) ... The above assumes that your date fields have no time component (all are exactly ...
    (microsoft.public.access.reports)
  • Re: Delete record howto?
    ... >DELETE * FROM YourTableName ... >Thanks for the fast comeback. ...
    (microsoft.public.access.formscoding)