Sum of unbound formula field column

I have a report with these 7 columns:

PO Value
Total Change Orders
PO Value + Change Orders (that is, Current contract value)
Total invoices
PO Val + Change Orders - invoices (balance remaining to invoice)
Payments made
Current contract value - total invoices (payments due)

I need a total at the bottom of "balance remaining to invoice". Since this is
an unbound formula field I cannot figure out how to write the formula for the
report footer totaling that column. Help?

This is the formula in that field: =Nz([Text88])-Nz([Text72]) this is
contract value - total invoices

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201004/1

=sum([text88]-[text72])
You can add the nz if you think there might be fields that contain zero.
--
Milton Purdy
ACCESS
State of Arkansas


"kathrynwoning via AccessMonster.com" wrote:

I have a report with these 7 columns:

PO Value
Total Change Orders
PO Value + Change Orders (that is, Current contract value)
Total invoices
PO Val + Change Orders - invoices (balance remaining to invoice)
Payments made
Current contract value - total invoices (payments due)

I need a total at the bottom of "balance remaining to invoice". Since this is
an unbound formula field I cannot figure out how to write the formula for the
report footer totaling that column. Help?

This is the formula in that field: =Nz([Text88])-Nz([Text72]) this is
contract value - total invoices

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201004/1

.

when I use this code, Access asks for Text88 and Text72

golfinray wrote:
=sum([text88]-[text72])
You can add the nz if you think there might be fields that contain zero.
I have a report with these 7 columns:

[quoted text clipped - 12 lines]
This is the formula in that field: =Nz([Text88])-Nz([Text72]) this is
contract value - total invoices

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201004/1

You can't sum controls. You can sum fields that are in the query.

Perhaps what you want is
= SUM([Po Value) + Sum([Change Orders]) - Sum([Invoices])

If it is possible that one of those SUMs is null then you will need to use the
NZ function around the individual SUMs.


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

kathrynwoning via AccessMonster.com wrote:
I have a report with these 7 columns:

PO Value
Total Change Orders
PO Value + Change Orders (that is, Current contract value)
Total invoices
PO Val + Change Orders - invoices (balance remaining to invoice)
Payments made
Current contract value - total invoices (payments due)

I need a total at the bottom of "balance remaining to invoice". Since this is
an unbound formula field I cannot figure out how to write the formula for the
report footer totaling that column. Help?

This is the formula in that field: =Nz([Text88])-Nz([Text72]) this is
contract value - total invoices

when I use this code, Access asks for Text88 and Text72
Access is trying to find those two object as fields in your source.

Create a formula using orignal field names.

--
Build a little, test a little.


"kathrynwoning via AccessMonster.com" wrote:

when I use this code, Access asks for Text88 and Text72

golfinray wrote:
=sum([text88]-[text72])
You can add the nz if you think there might be fields that contain zero.
I have a report with these 7 columns:

[quoted text clipped - 12 lines]
This is the formula in that field: =Nz([Text88])-Nz([Text72]) this is
contract value - total invoices

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201004/1

.