Is there a way to find second last record ID # ?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Can we find 2nd largest/maximum record id # ?

I can find maximum record ID #  but in one of my scenario i need to find second maximum record id #.

Photo of Gaurav Sharma, Certified Builder and Expert

Posted 3 years ago

  • 0
  • 1
The 2nd largest Record ID is the largest record ID subject to the condition that it is less than the largest Record ID.  I assume that you have a relationship.  If you have used a Summary field to get the largest record ID#, then do a lookup of that value down to the child table.  

Then make a second summary field (duplicate the first one if you like) but add in the filter that the Record ID is less than the highest Record ID.
Thanks Mark,

It works for me.