[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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 4

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___