Alpha Video Training
Results 1 to 3 of 3

Thread: Display Second Most Recent Record in Grid

  1. #1
    "Certified" Alphaholic Rich Hartnett's Avatar
    Real Name
    Richard Hartnett
    Join Date
    Nov 2002
    Location
    Bowie, MD
    Posts
    1,456

    Default Display Second Most Recent Record in Grid

    I have a web page that is used by a club secretary to take meeting minutes. There are several sections ("Old Business, New Business, Treasurer's Report," etc.), and in each section I have a small button that allows the user to look up the previous month's minutes in case he/she needs to quickly refer to them.

    The problem is that the lookup grid always shows the most recent record, which is actually the one he/she is currently on, so what I really need is to display the second to the most recent record.

    Is there any way to sort the record order of the lookup grid by "Ascending Minus 1?"

    Sort Order.JPG
    Sergeant Richard Hartnett
    Hyattsville City Police Department
    Maryland

  2. #2
    "Certified" Alphaholic Lance Gurd's Avatar
    Real Name
    Lance Gurd
    Join Date
    Jun 2005
    Location
    Southampton, UK
    Posts
    1,422

    Default Re: Display Second Most Recent Record in Grid

    Hi Rich,

    Assuming this is an SQL type database we are dealing with you could use
    SELECT MAX( col )
    FROM table
    WHERE col < ( SELECT MAX( col )
    FROM table )

  3. #3
    "Certified" Alphaholic Rich Hartnett's Avatar
    Real Name
    Richard Hartnett
    Join Date
    Nov 2002
    Location
    Bowie, MD
    Posts
    1,456

    Default Re: Display Second Most Recent Record in Grid

    Ah I knew I forgot something in my post. I am still using DBF tables.
    Sergeant Richard Hartnett
    Hyattsville City Police Department
    Maryland

Similar Threads

  1. Getting Parent Object Value to display in child new record grid
    By johnfletchertt in forum Mobile & Browser Applications
    Replies: 1
    Last Post: 06-15-2015, 12:22 PM
  2. How to select the most recent record from a set
    By davidv43 in forum Alpha Five Version 10 - Desktop Applications
    Replies: 2
    Last Post: 01-29-2013, 10:39 AM
  3. Starting grid display at particular record
    By GGAllen in forum Application Server Version 10 - Web/Browser Applications
    Replies: 0
    Last Post: 12-07-2011, 03:32 PM
  4. Only display most recent records by year
    By Rich Hartnett in forum Application Server Version 10 - Web/Browser Applications
    Replies: 9
    Last Post: 12-05-2010, 06:11 PM
  5. Last or Most Recent Record
    By forskare in forum Alpha Five Version 4
    Replies: 3
    Last Post: 01-06-2002, 04:51 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
  •