Modules public function

  • Thread starter Thread starter Frankie
  • Start date Start date
F

Frankie

I am trying to create modules for payroll taxes for a check.
I am starting simply by using two fields in a table.
HoursRg (LongInteger) * HourlyRt (Currency)
And call it in a report Control (Text30)
Any help would be appreciated

Thank You
Frankie
 
I am trying to create modules for payroll taxes for a check.
I am starting simply by using two fields in a table.
HoursRg (LongInteger) * HourlyRt (Currency)
And call it in a report Control (Text30)
Any help would be appreciated
Click to expand...

No module and no code is needed. Instead create a Query based on your table.
In a vacant Field cell type

TotalPay: [HoursRg]*[HourlyRt]

Set the Control Source of your Report textbox to TotalPay.

Or, base the report on your table or on a query selecting records from your
table, and set the control source of Text30 to

=[HoursRg]*[HourlyRt]

Doing it in the query lets you more easily sort by or filter by the total pay,
or calculate subtotals or grand totals on the report, should you wish to do
so.
 
Back
Top