Duane,
Good point. I was thinking in Excel again. I should just input the hours worked and then calculate the total hours whenever I need it. That is going to make the table design easier and I can calculate a total on a sub form.
For assigning hours to a specific project I am thinking I could have a combo box listed with a variety of projects. Each time hours were entered the appropiate project would have to be selected.
I will give it a shot and see how it goes.
Thanks,
Bill
MN
--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
> Bill,How about providing a justification for storing a value that should be calculated on the fly? Duane HookomMS Access MVP
> > To: MS_Access_Professionals@yahoogroups.com
> > From: Bill.Singer@...
> > Date: Sun, 9 Sep 2012 02:42:05 +0000
> > Subject: [MS_AccessPros] Running total
> >
> > I believe I remember code being posted for keep a running total in a table.
> >
> > I have to make a table that tracks employee hours, total hours and total hours on a specific project.
> >
> > Here are the field I am thinking.
> >
> > chrChrID - ID field
> > chrEmpID - Employee ID
> > chrHourWorked - additionial hours worked
> > chrTotalHours - default value would be a running total of all hours worked.
> >
> >
> > The problem I am having is I do not know how to make the field defauld value calculate by backing up a record and get a total and then add a new number to it.
> >
> > Any help would be greatly appreciated. I am still trying to figure out how to track project hours as well.
> >
> > Thanks,
> >
> > Bill
> > Minnesota
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar