If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Sum of unbound formula field column
=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 . |
#3
|
|||
|
|||
Sum of unbound formula field column
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 |
#4
|
|||
|
|||
Sum of unbound formula field column
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 |
#5
|
|||
|
|||
Sum of unbound formula field column
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 . |
Thread Tools | |
Display Modes | |
|
|