Employee Paysheet

[Melissa]

Hi there

I need to create a report for a "PaySheet" for each employee.

On my Paysheet, 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 Paysheet 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

 

[Philip Herlihy]

Hi there

I need to create a report for a "PaySheet" for each employee.

On my Paysheet, 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 Paysheet 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