Re: Calculations on report...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

As in for RRSP it will be entered on the form by the user.

Duane Hookom wrote:
I would rather not guess which of these are controls on reports or fields in
a report's record source. Did you tell us how "to see if there was an RRSP
contribution"?

Generically, you could create a user-defined function by opening a new blank
module and entering something like:

Function GetQCTax(pstrProvince as String, _
dblTotal as Double) as Double
If pstrProvince = "QC" Then
GetQCTax = dblTotal * 0.16
Else
GetQCTax = 0
End If
End Function

Save this module as "modTaxCalcs". In your report, you can set a control
source of a text box to something like:
=GetQCTax([PROVINCE], [TOTAL])

This database is used to calculate what the person is owed from
overpayment.
[quoted text clipped - 32 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

.

Relevant Pages

  • Re: Calculations on report...
    ... table since its a database and needs to be recalled later. ... the QRY which is in the record source for the report. ... ~Everyone needs a NEWFIE as a friend~ ...
    (microsoft.public.access.reports)
  • Re: Calculations on report...
    ... Is RRSP a bound control? ... Are you sure this is a reports question since you state RRSP is on a form? ... ~Everyone needs a NEWFIE as a friend~ ...
    (microsoft.public.access.reports)
  • Re: Calculations on report...
    ... is a report problem because I need the calcultions to be shown on the ... Is RRSP a bound control? ... ~Everyone needs a NEWFIE as a friend~ ...
    (microsoft.public.access.reports)
  • Re: Calculations on report...
    ... Ok, tell us what the fields are from your report's record source, what ... Duane Hookom wrote: ... ~Everyone needs a NEWFIE as a friend~ ...
    (microsoft.public.access.reports)