98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access
Access
Resolved · Urgent Priority · Version 2013
Fri 10 Oct 2014, 13:35Delegate Sheila said...
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
Fri 10 Oct 2014, 14:29Trainer Doug said...
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
Fri 10 Oct 2014, 14:39Delegate Sheila said...
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
Fri 10 Oct 2014, 17:12Trainer Doug said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
