Choosing working days

[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

 

[Alex Dybenko]

You can make a query which will group by Field1, sum Field3 and filter by
Field2 - here you can use datepart function to filter out sunday and
saturday.
also look at this page:
http://www.mvps.org/access/datetime/date0012.htm

 

[Guest]

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

 

[Alex Dybenko]

type DatePart("w",Field2) is a query, and it will return weekday of Field2.