Hi, I have a few forms for submitting employee payments to a database, the forms will then run a report to pull off certain payments within a certain date for a specific employee.
So I select employee, enter dates and click search. I then view report and all calculations are made based on pension etc...
I have my forms running off a query.
I it works fine if I didn't have to edit Pension %, but this field may need changing in the future. However if I change the pension band (which relates to a %), when I run the report, it changes all previous payments made under a different %. So yesterdays % could be 5% and todays could be 8%, when I run report to include today and yesterday, it pulls off pension % as 8% for both payments.
Is there a way of doing this without changing previous entries?
I thought running it from query would allow me to change pension % and keep my previous entries, but it appears not to do so.
Any help?
Cheers
Will
So I select employee, enter dates and click search. I then view report and all calculations are made based on pension etc...
I have my forms running off a query.
I it works fine if I didn't have to edit Pension %, but this field may need changing in the future. However if I change the pension band (which relates to a %), when I run the report, it changes all previous payments made under a different %. So yesterdays % could be 5% and todays could be 8%, when I run report to include today and yesterday, it pulls off pension % as 8% for both payments.
Is there a way of doing this without changing previous entries?
I thought running it from query would allow me to change pension % and keep my previous entries, but it appears not to do so.
Any help?
Cheers
Will
