Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    72

    Unanswered: select NOT in TOP 3 dates

    I have TAB1 with filed AGG (as date dd/mm/yyyy).
    I need to select all (with *) records based the oldest 3 dates in AGG.

    Example AGG:
    01/01/2010
    ....
    08/11/2001
    ...
    15/12/2011
    ...
    15/11/1989
    ....
    14/06/1957
    ...
    15/12/2011
    ....
    11/01/1988

    in this case... select * 15/11/1989, 14/06/1957...11/01988

    How to with a qyuery Access?

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Look at "DemoTOP3datesA2002.mdb" (attachment, zip).
    Table1, Query1MT, Query2, Form1 (VBA), Module1.
    Open Form1 and try.
    Attached Files Attached Files

  3. #3
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Also, it can be done on this way.
    Look at attachment (zip).
    Look at Query3, open Form1 and click on
    button 2.
    Attached Files Attached Files

Posting Permissions

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