Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Hello all,
    I have an excel spreasheet with about 100,000 records. Some of the records have the same values except for the date. What I would like to do is mark the record with an X that are the oldest. I am attaching a spreadsheet to show you an example. I can do this in Excel or Access but I need some help on how.
    Attached Files Attached Files

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Are you wanting to mark the oldest record for each of the records where they have the same identifier? Or just the oldest record in the table/worksheet? My take is that Access is a better choice if it is the former, as you can create a "Group By" query that identifies the oldest record fairly easily. Another issue that worries me is that the data may change over time and you will need a process to deal with that.
    Wendell

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    As Wendell said, marking the current "newest" record is somewhat problematic, as it could easily change. In Access, you'd just run a query to get the oldest record when you needed it, something like this:

    SELECT RecordID FROM tblRecords INNER JOIN (Select RecordID, Max(RecordDate) FROM tblRecords GROUP BY RecordID) AS subquery ON tblRecords.RecordID = subquery.RecordID
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts
    See of the attached DB is from any help.
    Import the Sheet1 table.
    Run the Make Table query.
    You get a new table with all the maximum dates only
    Attached Files Attached Files
    Francois

Posting Permissions

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