Can you describe how the data is set up in this table in more detail? Are the "related detail records" in the same table as the first record or in a related table?
Phil, many thanks for your quick response.
Yes, all records are in the same table. Just need to list sorted/filtered records in a summarized format to report them togethern.
I don't see anything "summarized" in your description.
While in layout mode, add a sub summary layout part "when sorted by Project Title".
Put the Project Title field in this sub summary layout part.
Put the "detail" fields for each of the records with this same project title in the body layout part.
Sort your records by Project Title to make the sub summary layout part appear as a "sub head" above each group of records with the same Project Title.
If you define summary fields in this table, you can add them to the sub summary layout part to show a subtotal based on all records in your found set with the same project title. Put the same fields in any other layout part and they'll show a grand total based on all the records in your current found set.
Got it. Exactly what I need to learn about the "sub summary". Thank you very much.