Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2012
    Posts
    20
    Provided Answers: 3

    Unanswered: Query that looks up all records for one month, three months previous to current date

    Hello,

    I would like to create a query that looks up all records for a month, three months prior to the current date. That is if I ran the query this month, it should pull up all the records for August. Can such a creature be created. The name of my date field is DateofHire. Thanks for your help in advance.

    Dave

  2. #2
    Join Date
    Oct 2012
    Posts
    20
    Provided Answers: 3
    Got it, close thread.

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Forum etiquette, here and elsewhere, requires that when a poster finds a solution elsewhere, or solves the probelm himself or herself, they post the answer! In this manner, others searching on a similar question can benefit from your experience.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Oct 2012
    Posts
    20
    Provided Answers: 3

    Solution

    Between DateSerial(Year(DateAdd("m",-3,Date())),Month(DateAdd("m",-3,Date())),1) And DateSerial(Year(DateAdd("m",-3,Date())),Month(DateAdd("m",-3,Date()))+1,0)

Posting Permissions

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