Skip to main content
Question

Can a Summary Field Identify Oldest or Newest Record ID.

  • April 27, 2017
  • 0 replies
  • 58 views
I'm working on an inventory/order process that takes into account FIFO - so i'm trying to ensure the oldest inventory records are added to an order automatically.  If I could carry over the oldest record ID from the inventory table, I can make it work.

I thought about trying to create a summary field that will show the oldest Record ID. Maybe oldest is the wrong word to use here, 'smallest number' might be more accurate since Record ID's only grow larger.  Can a summary field do this?  I attempted to create one that looked for the "minimum" Record ID, but it didn't return anything. 
      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • April 27, 2017
      The 'Minimum' record ID# is what you are looking for.  That odd that its not showing anything. 

      Do you add additional conditions to the summary field?
      • RyanParr
      • Author
      • Registered
      • April 27, 2017
      Thanks for letting me know that i'm on the right track.  I filtered the summary based off of another summary field that basically states if the Inventory was already issued.  I'll mess around with the conditions to see if i can get it to work.
      Terms & ConditionsAccessibility statement