I have a database which works fine for inputting weekly wages and calculating gross and nett totals etc.
each week a certain amount of cash is paid to workers as part of their wage.
we have a cash distribution form which is currently on microsoft excel, which means it is completed out of the database, which is not ideal.
i want their to be a form in access which has all the fields of the cash distribution form, but which also draws information from the data already input.
e.g.
Cash Distribution Form
Week No
Cash Available
Sub-Contractors Cash
PAYE Cash
Petty Cash
Other Receipts
Balance
The SubContractors Cash, PAYE Cash and Other Receipts can come from tblHours and tblP11 where the SubContractors and PAYE weekly hours are input.
Each week there are about 40 employees all with different amounts of cash or usually no cash. the field for SC Cash and PAYE Cash would need to add up the cash for all employees.
Also Petty Cash can be a default value each week.
The user should only need to input into the Cash Available cell.
From this i would then like to print a report in the above format with a balance. i can do this.
If anyone understands please help! thank you.
each week a certain amount of cash is paid to workers as part of their wage.
we have a cash distribution form which is currently on microsoft excel, which means it is completed out of the database, which is not ideal.
i want their to be a form in access which has all the fields of the cash distribution form, but which also draws information from the data already input.
e.g.
Cash Distribution Form
Week No
Cash Available
Sub-Contractors Cash
PAYE Cash
Petty Cash
Other Receipts
Balance
The SubContractors Cash, PAYE Cash and Other Receipts can come from tblHours and tblP11 where the SubContractors and PAYE weekly hours are input.
Each week there are about 40 employees all with different amounts of cash or usually no cash. the field for SC Cash and PAYE Cash would need to add up the cash for all employees.
Also Petty Cash can be a default value each week.
The user should only need to input into the Cash Available cell.
From this i would then like to print a report in the above format with a balance. i can do this.
If anyone understands please help! thank you.