Search results

  1. J

    Where to stick line this code?

    The following code calcuates the difference in work days between two dates: Function BusinessDays(PosHireDate, RepDate) As Long BusinessDays = (DateDiff("d", PosHireDate, RepDate) - _ (DateDiff("ww", PosHireDate, RepDate) * 2) + 1) + _ (Weekday(PosHireDate) = vbSunday) + _...
  2. J

    Workdays between two dates

    I have two dates: StartDate = 11/09/2009 ReportDate = 11/30/2009 I know that days elapsed is simply: [ReportDate] - [StartDate] = 21 Days But how do I get just WORKDAYS? The result would be 16 days in this example.
  3. J

    How do I AVERAGE and then SUM the Averages?

    I wrote a report which averaged by dept. the number of FTE (Full Time Equivalent or Headcount). However, If a manager has more than one department I need to add or sum the average of those departments. See attached file for an example. Is there any way to do this? Thanks! Jerome
  4. J

    Best Way to Expand Report as months are added

    I have a report that I created currently has months Jul – Nov by Department Departments listed as rows Months listed as columns FTE listed as value The report is based on a pivot query I created. As the new month’s data is added to the table and then added to the query, I don’t want to...
  5. J

    using a subquery for YTD and Month by Dept

    YTD subquery for Not working and causing me grief Help! I wrote a query which is supposed to add MONTH and YTD hours BY DEPT BY PERIOD BY YEAR The data pulls from the main table "Tbl_Hours_Actual" and then I'm trying to write a subquery off that table, but the YTD totals are goofy. If I...
Back
Top Bottom