SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Enthusiast
    Join Date
    May 2000
    Location
    Toronto
    Posts
    34
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Deleting Records from Access Database acording to expiration date

    I am working on a client site right now that requires a form with expiration dates due to software version level etc.
    I want to be able to delete records and accounts(or at least store them somewhere else) according to the expiration date.

    Would anyone have any advice on the best way to do this with ASP and Access.

    Thanks ahead.

    BQ

  2. #2
    SitePoint Wizard Goof's Avatar
    Join Date
    Feb 2001
    Location
    Pittsburgh, PA
    Posts
    1,154
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Use the following SQL statement:
    Code:
    DELETE FROM myTable WHERE [ExpDateField] < #" & expDate & "#;"
    Hope that helps,
    Goof
    Nathan Rutman
    A slightly offbeat creative.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •