setting a value in one record equal to the value in another record

setting a value in one record equal to the value in another record

Post by SldDcm9zYn » Thu, 05 Feb 2009 08:38:08


I'll see if I can explain this clearly...

I have a table that, among other things, has the following fields:
EmpllyeeID
OpeningBalance
EndingBalance (a calculated field)
Date

I only have one record per month; never two records for the same EmployeeID
in the same month.

I want the opening balance for one month to equal the ending balance in the
previous month (for the same EmployeeID).

So, when I work on some calculations in a particular month (via a form) and
it calculates the ending balance, I want it to also set the beginning balance
for the next month equal to that.

anyone follow that? I can put the code in an after update event if I knew
how to write it.

Thanks in advance.

Jerry
 
 
 

setting a value in one record equal to the value in another record

Post by Q2xpZmZvcm » Fri, 06 Feb 2009 07:41:23

Hi Jerry,

If you are working in say February, with March not yet here, do you
want to create a new record and then have to update it each time you enter
something into February? Or do you only want to put in the beginning balance
when March is started? Also, in February, do you make changes to January's
information, or earlier? So, if you make a correction in January 2007, you
then have to correct all of the succeeding months of data up through January
2009?

Clifford Bass