Access VBA Week Number of Year less Friday of that Week

**deer777** · 04-15-2012, 08:57 PM

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

**BrianMH** · 04-18-2012, 01:01 PM

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?

04-15-2012, 08:57 PM	#1
deer777 VBAX Newbie Joined: Apr 2012 Posts: 1 Kb Entries: 0 Articles: 0	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
Local Time: 06:53 PM Local Date: 05-21-2013 Location:

04-18-2012, 01:01 PM	#2
BrianMH VBAX Mentor Joined: Feb 2009 Posts: 481 Kb Entries: 1 Articles: 2	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.
Local Time: 12:53 AM Local Date: 05-22-2013 Location: