Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Location
    Winnipeg, MB, CA
    Posts
    16

    Unanswered: I need an expression for a delete query in Access

    *** I want to delete all records before april of this year. ***

    This simple choice it seems is to use a delete query. Although, I am having trouple finding the correct syntax for it.

    So far I have only been able to delete records from yesterday and before by using '<Date()' in the criteria box.

    -d3rt
    __________________________
    We can send a man to the moon,
    but heaven
    help us to weld vertices properly.

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    try <#2003/04/01#

  3. #3
    Join Date
    Oct 2003
    Location
    Winnipeg, MB, CA
    Posts
    16
    almost, but I need it to to be flexible, so that it will still work next year without having to update the query itself

    -d3rt
    __________________________
    We can send a man to the moon,
    but heaven
    help us to weld vertices properly.

  4. #4
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    then try <cdate(year(date()) & "/04/01")

Posting Permissions

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