help me please

[ياسر]

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

 

[Jeff Boyce]

Where are you trying to do this? Directly in a table? In a form?

It sounds like you are saying that the total (sum) of [Regular Hours] for
any one date must not exceed 8. I can imagine doing something like this
using a main form to hold the date and a subform to hold the hours. That
way, you can have the total of the subform's hours for a given day be <=8.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[ياسر]

I m doing this in subform with this details:
idnumber text
task combo box
date date/time
projectname combo box
work description combo box
regular time number fixed which is can't be more than 8 hours
for all the day even its in many rows for the sub form thats what i need to do
is to sum the total of regular time for each date in many records
So any help can you do for me?

Where are you trying to do this? Directly in a table? In a form?

It sounds like you are saying that the total (sum) of [Regular Hours] for
any one date must not exceed 8. I can imagine doing something like this
using a main form to hold the date and a subform to hold the hours. That
way, you can have the total of the subform's hours for a given day be <=8.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

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

 

[Jeff Boyce]

My previous suggestion was to put the date in the main form and use the
subform to record hours-on-project and date.

That way, you could use your mainform's date to limit the subform records
displayed. And you could also use a footer in the subform to add up the
hours for each date and trigger a validation message if the total exceeds 8.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I m doing this in subform with this details:
idnumber text
task combo box
date date/time
projectname combo box
work description combo box
regular time number fixed which is can't be more than 8
hours
for all the day even its in many rows for the sub form thats what i need
to do
is to sum the total of regular time for each date in many records
So any help can you do for me?

Where are you trying to do this? Directly in a table? In a form?

It sounds like you are saying that the total (sum) of [Regular Hours] for
any one date must not exceed 8. I can imagine doing something like this
using a main form to hold the date and a subform to hold the hours. That
way, you can have the total of the subform's hours for a given day be
<=8.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

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

 

[ياسر]

Thanks But That suggestion will not work with this case
because i need to put the date in the sub form so each employee will record
his work for all the month and and each day he may work in many tasks and
also he may not work for the current date now but after he finish his all
work then he can record what he did in the previous days
Also the main form takes its data from query which contain the employee
information just as id number - emp name- department- title
So i need to put the date in the sub form and do it as it looks like
So any help from you?

My previous suggestion was to put the date in the main form and use the
subform to record hours-on-project and date.

That way, you could use your mainform's date to limit the subform records
displayed. And you could also use a footer in the subform to add up the
hours for each date and trigger a validation message if the total exceeds 8.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I m doing this in subform with this details:
idnumber text
task combo box
date date/time
projectname combo box
work description combo box
regular time number fixed which is can't be more than 8
hours
for all the day even its in many rows for the sub form thats what i need
to do
is to sum the total of regular time for each date in many records
So any help can you do for me?

Where are you trying to do this? Directly in a table? In a form?

It sounds like you are saying that the total (sum) of [Regular Hours] for
any one date must not exceed 8. I can imagine doing something like this
using a main form to hold the date and a subform to hold the hours. That
way, you can have the total of the subform's hours for a given day be
<=8.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

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

 

[Jeff Boyce]

Perhaps another reader has experience doing what you have decided you need
to do. I don't.

Best of luck

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks But That suggestion will not work with this case
because i need to put the date in the sub form so each employee will
record
his work for all the month and and each day he may work in many tasks and
also he may not work for the current date now but after he finish his all
work then he can record what he did in the previous days
Also the main form takes its data from query which contain the employee
information just as id number - emp name- department- title
So i need to put the date in the sub form and do it as it looks like
So any help from you?

My previous suggestion was to put the date in the main form and use the
subform to record hours-on-project and date.

That way, you could use your mainform's date to limit the subform records
displayed. And you could also use a footer in the subform to add up the
hours for each date and trigger a validation message if the total exceeds
8.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I m doing this in subform with this details:
idnumber text
task combo box
date date/time
projectname combo box
work description combo box
regular time number fixed which is can't be more than 8
hours
for all the day even its in many rows for the sub form thats what i
need
to do
is to sum the total of regular time for each date in many records
So any help can you do for me?



:

Where are you trying to do this? Directly in a table? In a form?

It sounds like you are saying that the total (sum) of [Regular Hours]
for
any one date must not exceed 8. I can imagine doing something like
this
using a main form to hold the date and a subform to hold the hours.
That
way, you can have the total of the subform's hours for a given day be
<=8.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

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