Consulting

Results 1 to 2 of 2

Thread: Access VBA Week Number of Year less Friday of that Week

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Apr 2012
    Location
    DFW, TX
    Posts
    1
    Location

    Question Access VBA Week Number of Year less Friday of that Week

    I am trying to calculate a sum of a field called lines based on a specific week number of the year less one day of that week (Friday).

    Please help!

    Tks

  2. #2
    VBAX Mentor
    Joined
    Feb 2009
    Posts
    493
    Location
    Can you clarify what you mean by less one day of the week? Do you mean you want to calculate the weeknumber based on the start of the week being Friday? Or do you mean you don't want Fridays to be included in the calculation?
    -----------------------------------------
    The more you learn about something the more you know you have much to learn.

Posting Permissions

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