Search results

  1. D

    optimize performance for recurring query

    I have spreadsheet reports I generate for some clients on a weekly basis. Each report shows the activity for the previous week. I've built VBA that can run the query and send the report, but I'm hitting a major performance problem with regards to the query itself. If I manually enter the week...
  2. D

    Update query headache

    I've been assigned the task of tracking vacation hours for a small group of employees out in California. California has some interesting rules about employee vacation, among which is that once time has been earned, it stays available to that employee until they use it or are no longer employed...
Back
Top Bottom