Choosing working days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.
I have a table that stores information as follows:

Field1 Field2 Field3
a1 01/01/2005 3
a1 02/01/2005 8
.... ... ...
a1 07/01/2005 5
a2 03/02/2005 6
.... ... ...
What i need to do is to create another table with just one line for a1, a2,
etc, that stores the sum of field3 but only for working days starting from
the first date that appears for each record. For instance, for record a1 i
want the sum of field3 of 5 occurences but excluding Weekend days.

Is this possible?

Thanks
 
Thanks Alex, but now i have another question:
How can i make datepart function to return which week day Field2 represents?
 
Back
Top