Re: Calculations on report...

Tech-Archive recommends: Speed Up your PC by fixing your registry

This database is used to calculate what the person is owed from overpayment.

rpt_txt_Que_Tax = QUE TAX
rpt_txt_Fed_Tax = FED TAX
rpt_txt_Tot_ROEC = TOTAL


The first check is to see if there was an RRSP contribution. If there is a
contribution the FED TAX = TOTAL * 0. Then I need to check to see if PROVINCE
= QC. If it does the QC TAX = TOTAL * .16 and if not QC then QC TAX = TOTAL *
0.

If there was no contribution to RRSP made I have to check and see if
PROVINCE = QC. If so another check is to see if the TOTAL is > 5000 and if so
FED TAX = TOTAL * .10 and QUE TAX = TOTAL * .16 and if < 5000, FED TAX =
TOTAL * .05 and QUE TAX = TOTAL * .16. If PROVINCE <> QC then FED TAX = TOTAL
* .10 and QUE TAX = TOTAL * 0.

I hope this helps...

NEWF

Duane Hookom wrote:
You do know your field and control names as well as your specifications. We
don't know these without guessing. Can you explain so some one can assist?

Duane:
Thanks for advice but I'm still lost with what your saying to do. I am not
[quoted text clipped - 15 lines]
Newf
~Everyone needs a NEWFIE as a friend~

--
Newf
~Everyone needs a NEWFIE as a friend~

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200608/1

.