I have a text field for ages, where specific age ranges are marked (e.g., 7 -17, 18 - 28, 29 - 39, etc.). I now need to calculate the percent of records in each age range. How do I do this? I'm assuming I need to sort and use subsummaries, but what fields do I define that will get me the percent?

This should be easy, but I'm not sure how to do it.

One way to do it, if you also want to be able to view the results in browse mode, is to create a self-relationship based on the text field, then create a calculation number field of Count(relationship::serial) / Status(CurrentRecordCount).

This sounds good, but can you explain it a bit more? I don't know what you mean by self relationship. And what do I substitute in Count(relationship::serial). Should relationship be a field name?

I don't understand the syntax of these kinds of things very well.

Thanks for your help.