Search results

  1. C

    MSDN Workdays Function results cannot be averaged

    Net 2.0, Thank you for your request and I apologize for taking so long to reply... work took me in another direction for a while. I'd like to provide a simplified version of my DB to post and get feedback, but I can honestly say this won't be something I'll be able to do anytime soon, given the...
  2. C

    MSDN Workdays Function results cannot be averaged

    Thanks for the response... Yes and yes. The type is integer. Just to ensure that integer wasn't causing a problem with the average, I changed Workdays, nWeedkays, and nHolidays to Double... re-running the check you recommended now shows the type as double. I quadruple error checked the...
  3. C

    MSDN Workdays Function results cannot be averaged

    I've spent many hours searching forums for some conversation/solutions about this, but with no luck so here goes: I started with the MSDN basic VBA code for Weekdays and Workdays functions to give me the number of workdays between two dates. (see...
  4. C

    Expression changes data type

    So simple.... sometimes it's just too late in the day to be writing formulas. Thank you.
  5. C

    Expression changes data type

    New to forum but I've been reading, reviewing, and learning from this forum for a while... My question: I have a query the includes an expression that produces an HR deadline date based on an employee's hiring paperwork's start date and the HR pay-period's beginning and end date. I've written...
Back
Top Bottom