Sheila has attended:
Access Intermediate course
Access
i have an excel spreadsheet that records anualised hours, each month staff claim for the hours worked during the month. I would like something in access that records the Total anualised hours, the hours claimed to date and the remaining hours. if i enter s claim and this exceeds the remaining hours i need a prompt
RE: Access
Hi Sheila.
Can I just clarify. Do you want the data to be in an Access table or use the Excel spreadsheet and create a form or report in Access to calculate the totals?
Thanks
Doug
Best STL
RE: Access
I have an access database that holds all the details of the staff that work on anualised contracts.
Now i need a mechanism for recording
Annualised hours as a total
Total of each claim form (1 per month)
Remaining annualised hours but i need to see this as i enter the claims via a form
RE: Access
Hi Sheila
Thank you for for clarifying. The answer to your question is a little beyond the scope of our forum. I am passing it on to my account manger Daniel. He will be in touch shortly to discuss how best to have your question answered.
Best Regards
Doug Dunn
Best STL
