Calculating feilds

  • Thread starter Thread starter andrew12
  • Start date Start date
A

andrew12

In a report of mine I have two fields [ProjectedUnits] & [ProposalAmount]
First I am trying to get the sum of [ProjectedUnits] In the footer I used a
text box,
and I put =Sum([ProjectedUnits]) and it came up error on the report? Not
sure what I am doing wrong - please help

Also the ultimate goal is to get a projected revenue so essentialy I need
to muiltiply units by amount and get a sum of all those amounts
my footer will be as follows:
Total Projected Units:
Total amount Proposed:
Projected Revenue:
 
Andrew,

What is the name of the textbox? If it is the name of one of the fields
in the report's underlying Record Source query, you will need to change
it to something else.

Otherwise, I can't see anything wrong with your expression.

I think the Control Source expression to use for the Projected Revenue
textbox would be like this:
=Sum([ProjectedUnits]*[ProposalAmount])
 
Steve,

Hey the expression that I plugged in =Sum([ProjectedUnits]) works fine if
you put it in the report footer not the page footer - so I realize what i
did. Also the expression
=Sum([ProjectedUnits]*[ProposalAmount]) works great.
--
thanks,
-Andrew


Steve Schapel said:
Andrew,

What is the name of the textbox? If it is the name of one of the fields
in the report's underlying Record Source query, you will need to change
it to something else.

Otherwise, I can't see anything wrong with your expression.

I think the Control Source expression to use for the Projected Revenue
textbox would be like this:
=Sum([ProjectedUnits]*[ProposalAmount])

--
Steve Schapel, Microsoft Access MVP
In a report of mine I have two fields [ProjectedUnits] & [ProposalAmount]
First I am trying to get the sum of [ProjectedUnits] In the footer I used a
text box,
and I put =Sum([ProjectedUnits]) and it came up error on the report? Not
sure what I am doing wrong - please help

Also the ultimate goal is to get a projected revenue so essentialy I need
to muiltiply units by amount and get a sum of all those amounts
my footer will be as follows:
Total Projected Units:
Total amount Proposed:
Projected Revenue:
Click to expand...
Click to expand...
 
Back
Top