Re: Employee Paysheet

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

Melissa wrote:
Hi there

I need to create a report for a "Pay***" for each employee.

On my Pay***, I need the following information:

Normal time Worked: (Total Shifts, RatePerShift, and Rand)
Sunday time Worked: (Total Shifts, RatePerShift, and Rand)
Also, then a few deductions, such as UIF,etc.

Then on the Pay*** I need to have a field: Sub total, and then NettIncome.

My question is: Do I put the calculated fields (nett income, etc) in the query that the report is based on, or do I put a calculated text box on the report itself?

thank you

Melissa



In general, I think it's better practice to do your calculations in the query, as it's likely to be easier to understand when you (or someone else) needs to understand how it works. However, you can't create subtotals this way. You'd put a control (typically a text box) in the form/report footer (or the relevant group footer) with the ControlSource set to =sum([Rand]).

You may want to guard against problems caused by null values, so I'd make that =nz(sum(nz([Rand],0),0). (Look up NZ in help).

Phil, London
.

Quantcast