G
Grace
Hello,
I am working on a form that displays timekeeping
information. My challenge is this: I have a form that
contains a subform where a user will enter timekeeping
information. The data fields are:
[PIN] (this is the pk)
[Date]
[Project]
[Hours]
I want to have a subtotal of hours by date display on the
form so that as they are entering time, they can get a
running total of the hours by date.
I added a sum[(Hours]) field to the footer of the subform
and display it on my main form which works nicely, but I
would like to somehow display this by date. So, if the
record selected on the subform has a date value of
8/17/04, then the hours summed up would be for only
8/17/04. I think I need an IIf statement of some kind,
but do not know the syntax.
Any advise is greatly appreciated.
Thank you.
I am working on a form that displays timekeeping
information. My challenge is this: I have a form that
contains a subform where a user will enter timekeeping
information. The data fields are:
[PIN] (this is the pk)
[Date]
[Project]
[Hours]
I want to have a subtotal of hours by date display on the
form so that as they are entering time, they can get a
running total of the hours by date.
I added a sum[(Hours]) field to the footer of the subform
and display it on my main form which works nicely, but I
would like to somehow display this by date. So, if the
record selected on the subform has a date value of
8/17/04, then the hours summed up would be for only
8/17/04. I think I need an IIf statement of some kind,
but do not know the syntax.
Any advise is greatly appreciated.
Thank you.