GroovyNewton

Thank you very much. The Fraction of Total solution seemed the simplest solution and works well. Along the way I had another problem in that my original sort field was in a related file. The sort only worked for the purposes of the summary function after I put in a calculation field to give a text field in the primary file for the sort to work on.

I have a database in a single table with records that amongst other things contain a number field and a text field which are displayed on a layout. I have set up a second layout with a subsummary part containing a summary field for the total of number field values when sorted by the text field. The second layout also has a trailing grand summary part with the same summary field totalling the number field values. The second layout displays in preview mode. The second layout does not display the actual records. The result is that I get what I intended i.e. a series of subsummaries for each number value sorted by the text value and a grand total of these at the end. What I now want to do is to have a field for each subsummary that expresses the subsummary value as a percentage of the grand total value. However I have been unable to work out how to do this. Any suggestions would be much appreciated.

Thanks for the suggestion. Sorry but how do I "flag" a field? I have tried creating a new calculation field in the parent file that is equal to the summary but it shows the found records figure when on the parent layout and the all records figure when displayed on a child layout . So I am no further ahead.

My problem is that I have a summary field that works as I intend on the parent file by showing the summary of found records only. However when that same field is displayed on a child file it shows all summary of all the parent records. Can anyone explain how I can have the display on the child file correspond with the display on the parent file i.e. just the found records on the parent file.