i have 3fields which is Appliance, equipment and amount which is all in number value..

the value of which multiply depending on the number of records in the field the actual value..


saying:

if i have..
                        F0              F1            F2           F3              Total
Appliances        1                1              1                                3
Equipment        1                1                                                2
Animals             1                1              1             1                 4


but the report gives me a...
                    Total
Appliances     24
Equipment     24
Animals          24


what should i do? TY!

they all fit in one section..
all have the same formula..
and group then into "Person"
like..

Type of summary: sum
Evaluate: for each record
On change group: Group Person


the database looks like this

person.personid = appliance.personid and
person.personid = equipment.personid and
person.personid = animal.personid



Edited by ansai - 03 Nov 2009 at 4:36pm