Avatar

Level 2

I have a form that tracks comp time.  The form is simple - Name of the person and forwarding balance, then a table of columns for the date, amount earned, amount used, a notes field, balance available, and a line for the manager to check. 

I want begin with the balance going forward.  Once this amount is entered, all that has to be done is enter each line and update the balance.  The form is not dynamic.  I have sixteen lines on each page.  I figure, when the page is filled, they can print it off, put it in the worker's file and start a new page with the page's ending balance becoming the new balance forward on the next page.  So this means the Balance forward will be at the top of each page.

I don't know how to enter that previous balance and include it in calculations for the first line without isolating that line by itself and using another calculation for line 2-16.  Suggestions?

I am using Formcalc for my calculations.

Thanks for the assistance.