How to divide?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nicola - 12 Mar 2008 18:53 GMT

Hello - I'm having trouble dividing our Total Revenue by our Annual Volume to
get the average yield in my report. My formula in the control source is
=([Total Revenue]/[FXSP_ANNUAL_VOL])

Is there something I'm missing? Suming the two rows we're pretty straight
forward.

Thank for your help!

Reply to this Message

Stockwell43 - 12 Mar 2008 21:05 GMT

Hi Nicola,

See if this site helps. Maybe use the formula and change the names might work.

http://office.microsoft.com/en-us/access/HA010550731033.aspx

> Hello - I'm having trouble dividing our Total Revenue by our Annual Volume to
> get the average yield in my report. My formula in the control source is
[quoted text clipped - 4 lines]
>
> Thank for your help!

Reply to this Message