Calulation of days in date range

  • Thread starter Thread starter David Reid via AccessMonster.com
  • Start date Start date
D

David Reid via AccessMonster.com

Hi All,
I should pre-empt this post by letting all know I am very much a beginner
when it comes to both access and any form of programming:)

I am wrestling with an issue I hope someone can help me with.
I have a report that is generated, based on a date range called from a form
titled ScheduleReportForm.

The report calculates total hours worked during that date range for all
casual employees. I then need to convert the total hours to the equivalent
hours for full time employees.

The Sum for this is ((total hours as generated in the report) / ((days in
date range specified in the form)/ (divided by 6 working days)) /7.35)

I am unsure how to calculate the nett days worked from the date range
specified in the form.

Any assistance would be appreciated.

Regards,

David
 
I have listed the calculation incorrectly.
The company I work for trades Monday to Saturday. I want the field I am
trying to set to take the total hours worked in the date range specified,
and divide it by the days we have traded within the date range period.
this will give me the hours worked per day for the date range specified. Is
this even possible??
I then need to divide the daily hours by 7.35
 
David,
If I understand correctly...
DateDiff("d", "Forms!frmYourForm!StartDate, Forms!frmYourForm!EndDate)
should give you that number.
hth
Al Camp
 
David,
For Hours try...
DateDiff("h", "Forms!frmYourForm!StartDate, Forms!frmYourForm!EndDate)
hth
AlCamp
 
Thanks Al, that's helped alot.

Is there any way to lookup/ count the days between 'startdate' and
'enddate' , work out how many of them are Sundays (non trading days), and
subtract those Sundays from the total days?

That would give me the final figure I am looking for,
- Total days traded/worked during the date range specified.
 
David,
I've seen this question before... why don't you create a new post for
that question.
I'm not sure what's the best way to do that.
Al Camp
 
Back
Top