Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    1

    Unanswered: Weekend Removal from Averages

    I have a query that counts a number of items within a date range to produce an average via a report, This date range is from when the item was created till the item was closed.

    However! I need it to ignore weekends, the date ranges could be upto a year in lenth.

    Is there anyway i can filter out the weekends in the query?

    Thanks

    Steve

  2. #2
    Join Date
    Mar 2002
    Location
    Sacramento, CA
    Posts
    120

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •