simple layout, one database

field - author (text)

field - product (value list)

field - quantity (number)


I perform a find by author and sort by product for my report.

I have summary fields for the different product quantities.

These summary fields are the ones giving me grief.

1) Book One - 11 (product)
2) Book One - 21 (product)
3) Book One - 31 (product)

The summary total quantities for items 2 & 3 are doubling. I have
looked everywhere, don't know what to do.

Please help and thanks!


Mia

In article <1119287413.321670.14640 (AT) z14g2000cwz (DOT) googlegroups.com>,
mia.miarae (AT) gmail (DOT) com wrote:

Check the Summary field's definition is NOT set to be Running Total.

A Running Total will keep adding up over ALL the Found records, while a
Summary field with this turned off will only add up for the records
directly above or below it (depending on how the Summary layout part
was set) and then resets back to zero for the next grouping in the
report.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)