calculation based on a calculated value in a report

  • Thread starter Thread starter steely via AccessMonster.com
  • Start date Start date
S

steely via AccessMonster.com

I am trying make a calculation in a report based on another calculated
value in the same report. Can anyone tell me if this is possible? For
instance the first calculation in the report gives a calculation of
fish/per mile and I would like to multiply this calculation by another
number to a larger area. I tried to write the complex equation but received
an error message because of a variety of qualifiers used in the expression
(IIf[Year]=2005 and [subbasin]="PP].

Thanks.
 
steely via AccessMonster.com said:
I am trying make a calculation in a report based on another calculated
value in the same report. Can anyone tell me if this is possible? For
instance the first calculation in the report gives a calculation of
fish/per mile and I would like to multiply this calculation by another
number to a larger area. I tried to write the complex equation but
received
an error message because of a variety of qualifiers used in the expression
(IIf[Year]=2005 and [subbasin]="PP].

Thanks.
Click to expand...
 
Steely,
Marshall Barton responded to this question in your...
"sum fields based upon same ID number" posted on the formscoding newsgroup.
It's best to stay with one post to prevent duplication of effort on the
part of folks helping you out. This really is a "report" question, but
since you started in Formscoding... try staying with that until you (and the
folks working with you) run out of ideas.

Check Marshall's response...

I'll add one too...

Al Camp
 
Back
Top