Re: Summing Text Box

From: Jana (anonymous_at_discussions.microsoft.com)
Date: 02/17/04 

Date: Tue, 17 Feb 2004 08:17:01 -0800

Thank you for your assistance. I only gave you part of
the equation, but your advice helped me work through the
formula and it works great!

Once again, thanks.

>-----Original Message-----
>I'm guessing that the textbox showing this is in the
Detail section and you
>want to show the sum in a Footer section. I'm also
assuming the Workdays and
>StaffTotal are fields in the report. Place another
textbox in the detail
>section and set its Visible property to No. In its
Control Source type
>
>=IIf([Workdays]=1, [StaffTotal], IIf([Workdays]=2,
[StaffTotal]*1.25, 0))
>
>Below the Control Source set the Running Sum to Over All.
>
>In the footer, place a textbox and set its ControlSource
to point to this
>textbox.
>
>=txtSummingTextbox
>
>--
>Wayne Morgan
>Microsoft Access MVP
>
>
>"jana" <anonymous@discussions.microsoft.com> wrote in
message
>news:116e601c3f4e7$2c2a53a0$a401280a@phx.gbl...
>> I have made a report that has a calculated text box
based
>> on an if..then..else statement.
>> Sample
>> If workdays = 1 then
>> FTE= stafftotal *1
>> elseif workdays = 2 then
>> FTE=stafftotal *1.25
>> else:stafftotal=0
>> endif
>>
>>
>> I have the formula working correctly, but I would like
to
>> sum that value at the end of the report. I was assuming
>> that I could just sum the value of the FTE box but that
is
>> coming up with an error.
>>
>> Any help would be greatly appreciated.
>>
>> Jana
>>
>>
>
>
>.
>

Relevant Pages

  • Re: Total a Sum Iff expression
    ... I would expect a control source in a Report or Group Header or Footer ... =Sum([Total Whelped Females]) ... Sum(), Avg, Countare aggregate functions. ...
    (microsoft.public.access.queries)
  • Re: Report Sum Totals On Last Page
    ... "Duane Hookom" wrote: ... > All you should need is a couple text boxes in your Report Footer section. ... use a control source of: ... >> fix works to a degree for me, what I ultimately would like is just a sum ...
    (microsoft.public.access.reports)
  • Re: Summing Text Box
    ... I'm guessing that the textbox showing this is in the Detail section and you ... Below the Control Source set the Running Sum to Over All. ... In the footer, place a textbox and set its ControlSource to point to this ...
    (microsoft.public.access.reports)
  • RE: Get average using already calculated fields
    ... I am trying to sum a text box, of which the control source is a sum. ... "Duane Hookom" wrote: ... is important to understand the difference and accurately describe your report. ...
    (microsoft.public.access.reports)
  • Re: =Now() Function in Footer
    ... copy and paste into the control source property of the ... textbox and it's still producing an error. ... Did you use square brackets around "Enter Report ...
    (microsoft.public.access.reports)