please help me

[ياسر]

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 m using Time sheet with access 2003
and it works well
but i need help with this statement
So do you have offer for helping me ?

 

[ياسر]

Thanks but thats not working
i have entered about three records for the same idnumber with different
tasks for the same time but different hours but i didn't active the code you
write to me
i did this in sub form
-----------------------------------------------------------------------
date task event work description
regular time
------------------------------------------------------------------------
8/9/2009 projects BnP Bank Project manager
3
8/9/2009 projects BnP Bank Project director
5
8/9/2009 projects BnP Bank Project manager
4

----

12


9/9/2009 projects BnP Bank Project manager
4
9/9/2009 projects BnP Bank Project manager
5

------

9
----------------------------------------------------------------------
this is what i need to do
for the same date
the sum of all regular time for the same idnumber with different work
descriptions and different regular times can't be more than 8 for all the day
not for one row
and when user change date its value also is no more than 8 hours for the new
day with different rows for the same idnumber
Waiting for your replay and helps
It doesn't matter for the company for the fraction of hours
and this time sheet is not for payroll its calculate only how many time the
employee works on different projects and total time for the company for the
different projects thats all
so Wish you understand what i need and sorry for interrupting you but
please help its important to me to do this .

 

[ياسر]

Thanks but thats not working
i have entered about three records for the same idnumber with different
tasks for the same time but different hours but i didn't active the code you
write to me
i did this in sub form
-----------------------------------------------------------------------
date task event work description regular
time
------------------------------------------------------------------------
8/9/2009 projects BnP Bank Project manager 3
8/9/2009 projects BnP Bank Project director 5
8/9/2009 projects BnP Bank Project manager 4

----

12

New date:
9/9/2009 projects BnP Bank Project manager 4
9/9/2009 projects BnP Bank Project manager 5

------

9
----------------------------------------------------------------------
this is what i need to do
for the same date
the sum of all regular time for the same idnumber with different work
descriptions and different regular times can't be more than 8 for all the day
not for one row
and when user change date its value also is no more than 8 hours for the new
day with different rows for the same idnumber
Waiting for your replay and helps
It doesn't matter for the company for the fraction of hours
and this time sheet is not for payroll its calculate only how many time the
employee works on different projects and total time for the company for the
different projects thats all
so Wish you understand what i need and sorry for interrupting you but
please help its important to me to do this .

Thanks but thats not working
i have entered about three records for the same idnumber with different
tasks for the same time but different hours but i didn't active the code you
write to me
i did this in sub form
-----------------------------------------------------------------------
date task event work description
regular time
------------------------------------------------------------------------
8/9/2009 projects BnP Bank Project manager
3
8/9/2009 projects BnP Bank Project director
5
8/9/2009 projects BnP Bank Project manager
4

----

12


9/9/2009 projects BnP Bank Project manager
4
9/9/2009 projects BnP Bank Project manager
5

------

9
----------------------------------------------------------------------
this is what i need to do
for the same date
the sum of all regular time for the same idnumber with different work
descriptions and different regular times can't be more than 8 for all the day
not for one row
and when user change date its value also is no more than 8 hours for the new
day with different rows for the same idnumber
Waiting for your replay and helps
It doesn't matter for the company for the fraction of hours
and this time sheet is not for payroll its calculate only how many time the
employee works on different projects and total time for the company for the
different projects thats all
so Wish you understand what i need and sorry for interrupting you but
please help its important to me to do this .

What you describe sounds more like payroll data entry as opposed to a
timesheet. So all employees will input their hours directly into the
payroll database?

Try this for starters:
Set the form for ContinuousForm view, activate the Form Header/Footer,
add a control in the Footer with ControlSource of =Sum([Regular Hours])