Query help needed DESPERATELY

  • Thread starter Thread starter Cher
  • Start date Start date
C

Cher

I have been trying to solve this problem for months! I keep going back
to it with 'fresh eyes', to no avail. I read "Access 2000 for
Dummies" cover to cover... I must be a real dummy, because I still
can't get it.

I have created a report from my query. The form footer has 2 column
totals:

Total Project Cost (Actual column name is TPC)
This is the calculation I used to get it: =Sum([TPC])

and

Total Funded Amount
This is the calculation I used to get it: =Sum([Funded Amount])

I now need to calculate Total Leverage and place the total in the
report footer.

The calculation for total leverage on a calculator is:
Total Project Cost MINUS Total Funded Amount DIVIDED by Total Funded
Amount

I can not figure out how to do this. I do not know SQL.

Please help me - I am ripping out my hair on this!
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Create a calculated control on the report instead of in the query.

Put a TextBox where you want the Total Leverage to appear in the report
footer. Set it's Control Source property like this:

=([Total Project Cost] - [Total Funded Amount]) / [Total Funded Amount]


--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQJftL4echKqOuFEgEQIzPgCg3vMFaW6rA+xN/KdpTZJxEJAgIegAoOAw
0OLyYwFWk8BJujLbAx/HYnRo
=FGg1
-----END PGP SIGNATURE-----
 
Cher said:
I have been trying to solve this problem for months! I keep going back
to it with 'fresh eyes', to no avail. I read "Access 2000 for
Dummies" cover to cover... I must be a real dummy, because I still
can't get it.

I have created a report from my query. The form footer has 2 column
totals:

Total Project Cost (Actual column name is TPC)
This is the calculation I used to get it: =Sum([TPC])

and

Total Funded Amount
This is the calculation I used to get it: =Sum([Funded Amount])

I now need to calculate Total Leverage and place the total in the
report footer.

The calculation for total leverage on a calculator is:
Total Project Cost MINUS Total Funded Amount DIVIDED by Total Funded
Amount

I can not figure out how to do this. I do not know SQL.
Click to expand...

=(Sum([TPC])-Sum([Funded Amount]))/Sum([Funded Amount])

The above will throw an error if Sum([Funded Amount]) will ever be a zero.
 
Back
Top