Alpha Video Training
Results 1 to 4 of 4

Thread: Exporting Most Recent Records

  1. #1
    Ed
    Guest

    Default Exporting Most Recent Records

    I need to export the prices of items from a table that contains several price records of each item. For example, item 123456 has three price records, all entered at different times. It's the last price entry I need, as this is the most current price.

    The entry date is part of the record, but the dates vary. Some are recent, some are a few years old, so I can't filter by date.

    If anyone can offer some help, I'd appreciate it.

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Exporting Most Recent Records

    I handle this sort of thing by copying to a temporary table in date order, newest to oldest. The next step is to delete duplicate records by id (your item identifier field) in the temp table. This removes all the older records. You are then ready to export.

  3. #3
    Ed
    Guest

    Default RE: Exporting Most Recent Records

    Stan, thanks. I wasn't sure that the newest record would remain while older ones were deleted, but it works fine.

  4. #4
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Exporting Most Recent Records

    Alpha puts the power at your fingertips. You set the order of the records and that is the order used to determine which records are duplicates of the first value encountered. In your example you could sort the other way and find only the oldest records for each id.

Similar Threads

  1. Exporting and Posting Records
    By Scott Rusoff in forum Alpha Five Version 5
    Replies: 2
    Last Post: 06-27-2003, 08:32 AM
  2. Exporting Records
    By Scott Rusoff in forum Alpha Five Version 5
    Replies: 0
    Last Post: 06-26-2003, 12:52 PM
  3. Exporting & Updating records
    By Rachel Hardy in forum Alpha Five Version 4
    Replies: 2
    Last Post: 07-24-2002, 03:18 PM
  4. Last or Most Recent Record
    By forskare in forum Alpha Five Version 4
    Replies: 3
    Last Post: 01-06-2002, 05:51 AM
  5. most recent entry only
    By Valerie J. Breitbach in forum Alpha Five Version 4
    Replies: 1
    Last Post: 05-29-2001, 10:03 AM

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
  •