Thanks Matt. The problem with the Order By and Aggregates is that the Ordering field has to be included in the Grouping. Kris doesn’t want a Grouping row for every age.
I’m not giving up on this though. I think we can produce a solution for Kris.
Ok, I just read through this whole thread. Can someone explain why adding AgeRange (the text field) to the ORDER BY clause doesn’t produce the desired result?
Also, could Kris add a second field update to the workflow rule which would update an ‘index’ field?
Thanks Matt & Rob. I do have the AgeRange (text field) in the order by clause…
Matt - I’m thinking about what you’re saying about the 2nd field update and think i have an idea of what you’re saying and will try it…will let you know how it goes.
Thank you again soooo much! I can’t tell you how much I appreciate y’all and the support from this community!
Kris