Report Sum/If Statement

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have a report that I am writing that will be summing footer sections with
twist. I want to have the sum function state "0" if the days outstanding is
greater than 2. However, if the days outstanding is less than or equal to 2
I want the report to sum the count.

The formula that I am using is:
=IIf([WU Day Count]>2,0,Sum([CountOfENTRY_NUM1]))

This is working great if there is only a single line to add on either side
(>2 or <=2) or if there are no instances of records >2 days, however if there
are multiple lines where the days outstanding could be a number of days
(including the record where the days outstanding is >2), it is adding all of
the days .

Can you please help me??

Ultimately, I want to compare all values to the sum (count of records <2 days)
and report a percentage.

.

Relevant Pages

  • Re: Report Sum/If Statement
    ... University of Maryland Baltimore County ... I want to have the sum function state "0" if the days outstanding ... I want the report to sum the count. ...
    (microsoft.public.access.reports)
  • Re: Report is making too many numbers
    ... My report is grouped by Vendor, then Project, ... source query before putting it in the report so every record shows). ... A Running Sum text box accumlates its total. ... I've got a problem with Sum Totals at the end of a report, ...
    (microsoft.public.access.reports)
  • RE: Crosstab query dynamic columns ala Duane Hookom
    ... "javablood" wrote: ... I was trying to sum in the footer. ... "Duane Hookom" wrote: ... not too worried about getting this aspect of the report to work because I ...
    (microsoft.public.access.reports)
  • Re: Report is making too many numbers
    ... And you want to display the sum of in the Vendor header or footer ... My report is based on a query. ... A Running Sum text box accumlates its total. ... records--you could create a Totals query by depressing the Total ...
    (microsoft.public.access.reports)
  • RE: How to add a total from three other sums in a report
    ... Sometimes the report totals each record correctly sometimes not. ... "Jeff C" wrote: ... However the NZ sum of all three text boxes is adding correctly. ...
    (microsoft.public.access.reports)