Using If/When type expressions in a report

From: Linda Wampach (wampachl_at_ohsu.edu)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 15:22:25 -0700

I want to create a field within a report based upon
whether another field is true or false. Not only that,
but I want to be able to calculate that field. For
instance:

Typically, the TOTALUNITS field would be calculated by
using a =Sum[Units]expression. I want to be able to
multiply the TOTALUNITS by .7 if another field (yes/no
field) called MANAGER is = yes. Otherwise, I want to just
sum the field.

I need to do this in the report.

Any ideas?

Relevant Pages

  • Re: Portage, WI: FLorida DCF Link to case -- bad handling
    ... TALLAHASSEE - Fresh from serving time in a Colorado prison on fraud charges, Candice Clark returned to living with her daughter, Courtney, last August despite orders from a case manager that mother and child were not to be left alone. ... Such are the findings in a report by the state contractor entrusted with the welfare of Courtney Clark, a Pinellas County foster child who turned up with her mother this month at the site of a gruesome crime scene in Wisconsin. ...
    (alt.true-crime)
  • 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: 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)
  • Minutes of RSGB Board Meeting 19 January 2008
    ... Peter Kirby G0TWW General Manager ... The President, Colin Thomas G3PSM, opened the meeting and welcomed the ... Pathfinder Group Interim Report previous item 3.1.5. ...
    (uk.radio.amateur)
  • 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)