VBA Code to manipulate value of text

  • Thread starter Thread starter Benjamin Riley
  • Start date Start date
B

Benjamin Riley

I have a report that pulls the wages of employees from a
table. I wanted to have another textbox in to display each
employee's overtime rate. I have tried to get the code
right, but cannot seem to make it work. It always gives me
a runtime error.

Can anyone help?


BEN
 
Hello Ben,

Assuming you have a field that contains the employee's
base hourly rate, I would do the following:

In the query that supplies the recordsource for the report
create a field called OTRate as follows:

OTRate: ([RATE]*1.5)

Assuming you pay time and a half for overtime.

Include this field in the query and use it on the report.

Hope this helped.

Thanks,

ET Sherman
 
Back
Top