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@at-group.net
> 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