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
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

Signature
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com
> Hello.
> I have a table that stores information as follows:
[quoted text clipped - 15 lines]
>
> Thanks
Luis - 02 May 2005 13:55 GMT
Thanks Alex, but now i have another question:
How can i make datepart function to return which week day Field2 represents?
> 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
[quoted text clipped - 21 lines]
> >
> > Thanks
Alex Dybenko - 02 May 2005 16:45 GMT
type DatePart("w",Field2) is a query, and it will return weekday of Field2.

Signature
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com
> Thanks Alex, but now i have another question:
> How can i make datepart function to return which week day Field2
[quoted text clipped - 27 lines]
>> >
>> > Thanks