L
Luis
Hello. I've posted this question earlier and Alex posted a solution that i've
already implemented. The question i now have is the following:
I want that the sum of Field3 is restricted to only the first 5 Week days at
the maximum. is it possible to do it on the query or should i use VBA to do
this?
Note that som Field1 records can have less than 5 days of data and i also
want to sum this data.
Thanks.
Luis
---------
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
already implemented. The question i now have is the following:
I want that the sum of Field3 is restricted to only the first 5 Week days at
the maximum. is it possible to do it on the query or should i use VBA to do
this?
Note that som Field1 records can have less than 5 days of data and i also
want to sum this data.
Thanks.
Luis
---------
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