+ Reply to Thread
Results 1 to 2 of 2

Fetch first attempt date and last attempt date

  1. #1
    Forum Contributor
    Join Date
    11-26-2013
    Location
    India
    MS-Off Ver
    2010
    Posts
    157

    Fetch first attempt date and last attempt date

    Hi,

    Am in basic stage of access, i have two tables one is master data and the another one is day wise updated data

    my unique number is in my column Account number in day wise table i had multiple attempt on the perticular account number i need to fetch the first attempt date and last attempt date in new table (Report) table feilds are

    Account number from Master table and First attempt (day wise table), last attempt (day wise table)

    thanks in advance

    Liju

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    7,257

    Re: Fetch first attempt date and last attempt date

    Get the Min() date value form the master and the Max() for the date values in the second file.
    Then you have the first attempt (the Min()) and the last Attempt (the Max())

    Hope this gives you an idea, I don't work with access but it is just a question of logic
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Forum poorly again ... second attempt
    By TMS in forum Suggestions for Improvement
    Replies: 2
    Last Post: 01-27-2016, 10:23 AM
  2. Constructive criticism on first VBA attempt
    By gogreenpower in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-03-2014, 03:36 AM
  3. [SOLVED] Attempt to fetch data from another file using OFFSET() failed
    By billj in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2013, 09:49 AM
  4. Attempt Copy and Paste
    By Puzzled in Philly in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-01-2010, 06:22 PM
  5. Do until code attempt..
    By hachiroku in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2006, 08:46 AM
  6. Stored Procedures - First Attempt
    By Jim Heavey in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-07-2006, 07:30 PM
  7. [SOLVED] my first attempt at R1C1 in vba
    By goss9394@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-05-2005, 12:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1