- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
The form is on its way.
I modified the names of the row in the table Subform2.Total. I changed Row1 to Header and Row2 to Row because it helps me understand the structure of the table easier.
The problem is in your calculate event for the Total. You need to sum each column before you subtract. I changed it from...
// form1.DV.Subform2.Total::calculate - (FormCalc, client)
sum(Table1.Row2[*].FeeDue[*]) - (Table1.Row2[*].Ramount[*])
to...
// form1.DV.Subform2.Total::calculate - (FormCalc, client)
sum(Table1.Row[*].FeeDue[*]) - sum(Table1.Row[*].Ramount[*])
Steve
Views
Replies
0 Likes
Total Likes