Sum Totals

[coolcatkelso]

Hiya

Access 2007

I have a field called Amount Due
The control source for this is

=Forms![Workorders by Customer]![Workorders by Customer Subform].Form![Workorder Total]-nz([Total Payments])

on the footer of that sub I have an unbound field called text4

How can I sum this and show the total amount owed by customer?

I tried Using =Sum([Workorder Total]-[Total Payments]) but returns #Error

Cheers
Harry
________
PRE-PAID LEGAL SERVICES FORUMS

 

[John Big Booty]

This thread may help you

 

[coolcatkelso]

Hiya

Looked through the link but still couldn't get this going

The control source for my AmountDue filed is

=Forms![Workorders by Customer]![Workorders by Customer Subform].Form![Workorder Total]-nz([Total Payments])

I have an unbound field on the footer

Tried, nzsum, dsum and sum but everything seems to return #Error

Heres the database..

The Form in question is the last form in the list - Workorders by Customer Subform
________
Harmed By Paxil