Newbie, how to summarize a calculated field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

verci - 31 Oct 2005 03:59 GMT

Hi
I've the following text boxes in the group header section of my report, they
do not obtain the data source from any table they are calculated fields:
txtSubtotal = Sum([Import])
txtTax = ([Subtotal]*10)/100
txtRetetion= IIf([Retention]=True,(([Subtotal]*4)/100),"")
txtTotal =
IIf([Retention]=True,(([Subtotal]+[text35])-[Text37]),[Subtotal]+[text35])

What I want is to put on the reports footer section the summarize grand
total of all the values returned by these calculated fields, i.e
. txtGranSubtotal would hold the summarize value of txtSubtotal
txtGranTaxt would hold the summarize value of txtTaxt
txtGranRetetion would hold the summarize value of txtRetention
txtGranTotal would hold the summarize value of txtTotal

So far I'm stuck, any help would be very appreciated!!!!!!

Best regards

Reply to this Message

Duane Hookom - 31 Oct 2005 04:33 GMT

Aren't Import, Subtotal, and Retention fields in your report's record
source? You should be able to use the same expressions in the report footer
that you use in the group header/footer.

You haven't provided any information on what text35 and Text37 are from?

Signature

Duane Hookom
MS Access MVP
--

> Hi
> I've the following text boxes in the group header section of my report,
[quoted text clipped - 16 lines]
>
> Best regards

Reply to this Message

verci - 31 Oct 2005 05:44 GMT

ok , Import is a field in my invoice table that holds the inicial value of
any given article, Retention is a boolean field in my invoice table, and
Subtotal is a calculated field .

text35 = txtTax and Text37 = txtRetention so the IIF clause would be:

IIf([Retention]=True,(([Subtotal]+[txtTax])-[txtRetention]),[Subtotal]+[txtT
ax])

thanks!!!!!

> Aren't Import, Subtotal, and Retention fields in your report's record
> source? You should be able to use the same expressions in the report footer
[quoted text clipped - 15 lines]
> > txtRetetion= IIf([Retention]=True,(([Subtotal]*4)/100),"")
> > txtTotal =

IIf([Retention]=True,(([Subtotal]+[text35])-[Text37]),[Subtotal]+[text35])

> > What I want is to put on the reports footer section the summarize grand
> > total of all the values returned by these calculated fields, i.e
[quoted text clipped - 6 lines]
> >
> > Best regards

Reply to this Message

Duane Hookom - 31 Oct 2005 15:48 GMT

In any group or report header or footer, you should get totals using fields
from your report's record source. Don't create an IIf() function that might
return a number or might return a string ("").

Rather than referencing control names in your expressions, use the control
sources from those controls.

You didn't suggest how [Subtotal] is derived.

Signature

Duane Hookom
MS Access MVP
--

> ok , Import is a field in my invoice table that holds the inicial value of
> any given article, Retention is a boolean field in my invoice table, and
[quoted text clipped - 43 lines]
>> >
>> > Best regards

Reply to this Message