Sum of unbound formula field column

[kathrynwoning via AccessMonster.com]

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

 

[golfinray]

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

 

[kathrynwoning via AccessMonster.com]

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

=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

 

[John Spencer]

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

 

[KARL DEWEY]

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.

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

=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

--



.