Ù
ياسر
how can i calculate the sum of many rows for one day?
i mean :
i have a sub form with the following fields:
date - task- department -work description - Regular Hours - Over Time
by the way regular time must not be more than number 8
what i need is:
when user insert in the date for example:
1/1/2009 and ended with regular time he put 3 then the remained regular time
is 5
then in new record we insert the same date but the regular time must not be
more than the remained number ( 5 )
so
what i need is to sum the total numbers inserted for the same date so that
user can't input more than number 8 in all the sub records for the same date
but in new record with other date the numbers is to begin from 1 to 8
no more
so help me please
i mean :
i have a sub form with the following fields:
date - task- department -work description - Regular Hours - Over Time
by the way regular time must not be more than number 8
what i need is:
when user insert in the date for example:
1/1/2009 and ended with regular time he put 3 then the remained regular time
is 5
then in new record we insert the same date but the regular time must not be
more than the remained number ( 5 )
so
what i need is to sum the total numbers inserted for the same date so that
user can't input more than number 8 in all the sub records for the same date
but in new record with other date the numbers is to begin from 1 to 8
no more
so help me please