Windows 7 32bit 
Access 2007
Good day,
I need some assistance please.
I have a payroll set up in access.
Salary is paid semi-monthly, but deduction for income tax is done once at the end of the month.
I set up a field in the query that creates the payroll called payperiod eg 20172...for Feb 2017. This reads from a table with the data called Payrolltable. I also have a query that accumulates the pay for all payments with payperiod 20172. I want a query that brings the total for the month into the current payroll so the tax can be calculated on the total salary for the month.
The criteria is set in a dialog form for both the queries.
Social Security Number Gross PayPeriod 000451227 2500 20172 000456125 3000 20172 000488028 4000 20172 000488029 1500 20172
ID Beginning Date Ending Pay Period Name PayPeriod Payroll Table.Gross Total for month salary Register Report Mthly.Gross 50 2/15/2017 2/28/2017 Florez Abram 20172 1250 1500 50 2/15/2017 2/28/2017 Florez Abram 20172 1250 4000 50 2/15/2017
2/28/2017 Florez Abram 20172 1250 3000 50 2/15/2017 2/28/2017 Florez Abram 20172 1250 2500 51 2/15/2017 2/28/2017 Cooper Lee 20172 1500 1500 51 2/15/2017 2/28/2017 Cooper Lee 20172 1500 4000 51 2/15/2017 2/28/2017 Cooper Lee 20172 1500 3000 51 2/15/2017 2/28/2017 Cooper Lee 20172 1500 2500 52 2/15/2017 2/28/2017 Sylvester Robin 20172 2000 1500 52 2/15/2017
2/28/2017 Sylvester Robin 20172 2000 4000 52 2/15/2017 2/28/2017 Sylvester Robin 20172 2000 3000 52 2/15/2017 2/28/2017 Sylvester Robin 20172 2000 2500 53 2/15/2017
2/28/2017 Sprat Jack 20172 750 1500 53 2/15/2017 2/28/2017 Sprat Jack 20172 750 4000 53 2/15/2017 2/28/2017 Sprat Jack 20172 750 3000 53 2/15/2017 2/28/2017 Sprat Jack 20172 750 2500
Please for some advice.
Cristina
Reply With Quote
