Brenda,

Create a group in the report (if it is not yet there) based on the field in relation. Add two report variables:
- var1 having initial value 0, value to store 1, calculate COUNT, reset on the group
- var2 having initial value 0, value to store iif(var1=1,amount,0), calculate SUM, reset on the report end.

Var2 should give you the total for the parent table.

>The table is already selected and contains all the data that I can use. I am only allowed to make my changes in the report designer. I am helping a client who uses third party software to create the table and takes me right to the report designer.
>
>Brenda
>>You do not need to change anything in the table:
>>
>>use (yourtable)
>>sum (field_name) to variable_name