Thread: Using DateDiff
View Single Post
  #1 (permalink)  
Old November 26th, 2005, 05:44 PM
iancrabtree iancrabtree is offline
Registered User
Join Date: Nov 2005
Location: , , United Kingdom.
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Using DateDiff


I have an Employee database which has three tables. I have the employee table for employee details, a holiday table and a sickness table. I'veset up the relationships etc and a for which displays info about an employee. I can insert (through the form) a start and end date of a holiday or a sickness/absence and I want to calculate the number of working days the employee has had off each time. For example, an emplyee has 20 days holiday entitlement, and if an Employee books a holiday I want the form to deduct the total number of working days from the holiday entitlement. How do I implement this within the form? If I have a DateDiff function in a module, how do I get the form to use this function?

I'm a newbie to access, please help!



Reply With Quote