Calculating feilds

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

andrew12 - 07 May 2008 21:00 GMT

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:

Signature

thanks
-Andrew

Reply to this Message

Steve Schapel - 08 May 2008 00:25 GMT

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])

Signature

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
[quoted text clipped - 8 lines]
> Total amount Proposed:
> Projected Revenue:

Reply to this Message

andrew12 - 08 May 2008 13:51 GMT

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.

Signature

thanks,
-Andrew

> Andrew,
>
[quoted text clipped - 20 lines]
> > Total amount Proposed:
> > Projected Revenue:

Reply to this Message

Rate this thread: