I have a group that flies several trips a year on different airlines. I am trying to find a script/calc that will figure each passengers YTD Award Miles per airline for inclusion on the report given to the group leader. The leader gets this report every time flights are booked.

Fields include; Passenger Name (drop down list), Airline (drop down list), AwardMiles (this trip) and YTD Award miles.

The reason for this is so the Group Leader can keep an eye on YTD miles in order to keep or upgrade their passenger status for each airline.

This is the best way I know to explain. Please let me know if more info is needed.

TIA...

Welcome to the forums. If you go to Layout Mode and make a new layout, it will guide you through the steps of creating a report that summarizes your data.

Or you can do the steps yourself: create a summary field for the miles, then make a layout with subsummary parts for passenger and airline, then sort by those fields.