Sum of unbound formula field column
in [Reports]
|
From: kathrynwoning via AccessMonster.com on 22 Apr 2010 14:35 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/Forums.aspx/access-reports/201004/1
From: golfinray on 22 Apr 2010 15:38 =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/Forums.aspx/access-reports/201004/1 > > . >
From: kathrynwoning via AccessMonster.com on 22 Apr 2010 16:15 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/Forums.aspx/access-reports/201004/1
From: John Spencer on 22 Apr 2010 16:34 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 >
From: KARL DEWEY on 22 Apr 2010 17:04 >> 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/Forums.aspx/access-reports/201004/1 > > . >
|
Pages: 1 Prev: Report title based on Date? Next: Report will not stop calculating |