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

 

[June7]

Are you trying to build an entire payroll program? or just a timesheet?

If the first case I suggest you cry 'uncle' and go by one off-the-shel
such as Quickbooks. Cost about $200 and is far cheaper than trying t
program from scratch. The complexities of labor and tax laws and th
time calcs just aren't worth dealing with except for a professiona
design team and I get that you aren't. Don't reinvent the wheel.

If is the second case, use Excel. I work for state government and tha
is what our agency uses. Each employee has a copy of the workbook tha
serves as a time and attendance record which they fill in and print fo
submittal to payroll office. It incorporates checks of daily hou
totals. Don't think involves any VBA code. All done with in-cel
formulas

 

[ياسر]

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 ?

 

[June7]

What you describe sounds more like payroll data entry as opposed to
timesheet. So all employees will input their hours directly into th
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]

 

[ياسر]

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

 

[June7]

Not payroll but the information is getting saved into a database?
can't visualize this, would need to work with project and can't spar
effort to build one. Try to attach to a post here and I will look at
Access projects have to be in zip folder