How do I calculate number of days between 1st and last record in a report?
Posted on 2007-04-06
Using MS Access, I've built a database for our Publishing shop that each artist uses to track the amount of time spent designing & revising each of their jobs. A report can be generated for a each job that lists every date the job was worked on, and the number of minutes it took each time. While I have figured out how to get the total number of hours a job took, what I haven't been able to do is calculate the total number of days this job was worked on (i.e, the job may be in our shop for 10 days, the artist may have worked on it 4 different times, for a total of 2 hours, over the course of the 10 days). Would I use the DateDiff, and how would I indicate subtracting the most recent date from the earliest date generated in the report, to get the total number of days, and I only want to include "business days" (Monday to Friday)? Thanks!