date/ time type query

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • NWLPM
    #1

    date/ time type query

    I am a beginner MS Access user and need to write a query that will
    extract records that are older than 30 days.
    Tags: None
    • Robert
      #2
      Re: date/ time type query

      nwlpm@yahoo.com (NWLPM) wrote in message news:<c0eaef93. 0309110944.34b6 7f1@posting.goo gle.com>...[color=blue]
      > I am a beginner MS Access user and need to write a query that will
      > extract records that are older than 30 days.[/color]

      this is pretty but it works for me...

      Field: 30DayRecords: DateDiff("d",[YourDateFieldNa me],Date())
      criteria: >30

      Hope this helps,

      Robert F

        Comment

        Previous template Next
        Working...