Results 1 to 6 of 6
  1. #1
    kolsen is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    13

    Compare Dates in Query- another newbie question


    I have a query that reports all training received by a specific member, in a subform.

    I have it working great but now I need to modify it to select dates only after the member's renewal date

    I have tried a couple of ways to set the criteria in the query >[Member].[Renewal Date] etc. I am afraid I cannot seem to find a reference anywhere to how to compare the two dates in a query in this manner

  2. #2
    kolsen is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    13
    Worked it out :-)
    Now let me see if I can work out how to compare against a range

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Care to post your solution? Maybe it will help some future user........


    BTW, it is best programming practice if you do not use spaces in object names.......

  4. #4
    kolsen is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    13
    When I complete it sure

  5. #5
    kolsen is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    13
    So I am sure I could have done it by using [Query Name].[Field Name] but since I had the two dates on the form, I did this.....
    >[Forms]![Tracker]![cntcommencedate] And <[Forms]![Tracker]![cntrenewaldate]

    Attachment 26087

  6. #6
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Thanks...

    BTW, the attachment is an invalid link.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Statistical Query Question - Newbie
    By DNDPMick in forum Queries
    Replies: 2
    Last Post: 01-18-2016, 06:15 AM
  2. Replies: 3
    Last Post: 11-09-2015, 10:38 AM
  3. Replies: 1
    Last Post: 02-17-2012, 04:43 PM
  4. Newbie has a Query Question
    By Bruce in forum Queries
    Replies: 2
    Last Post: 11-20-2009, 10:38 AM
  5. Replies: 5
    Last Post: 08-05-2009, 12:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums