How to add up fields on a layout

[philipcaplan]

I have a "flat-file" type of database (ie, only one table) in FMPro 6 (under MacOS9).

A (numeric) field contains a calculated result for each record.

I have a script which searches for those records which meet a certain criterion, and then displays them in a columnar layout.

What I can't figure out (silly me!) is how to display on that layout the sum (total) of that field for all the found records which are appearing on that layout.

Thanks in anticipation. PHILIP CAPLAN

[aaa]

Create field Your_Total which is summary of Your_Calc_Field, then put it in footer in your layout.

[philipcaplan]

Thanks, aaa!

I must admit, I don't understand how, but that works!!

(I guess I'm going to have to do some learning about the "Summary" type.)

Thanks once again. PHILIP