Good day , I have a field which list all deductions and earnings for a companies Payroll.
I designed a report for the company and I need to separate the data in the one field into 2 subreports or list all deductions on the right and earnings on the left. i have already tried a conditional formula to say if is like any earning do not show on deductions side. Here is an example of what i want to accomplish
here is the values from that field.
Regular
Holiday Pay
Bosl ( bank charges)
PAYE (Pay as you Earn)
National Ins.
Other Deductions
Service Charge
Tips
Overtime
Cash Advance
I would like these values which are all generated from one field to be placed into two subreports or fields.
1.
Earnings:
Holiday Pay
Regular
Tips
Overtime
Service Charge
2.
Deductions:
Cash Advance
Other Deductions
Bosl (bank charges)
Paye (pay as you earn)
National Ins.
i have been working on these for a month now , any help would be greatly appreciated.
Regards,
Teddy
------------- T.Calderon
|