Adding Amount and checking daily In Hand amount

[rehanemis]

Hi Professionals,

I have One table(and designed form from it) in which i have recording the daily transactions(it is like a daily book). Daily transactions took place like Purchase of items of Amount 45, sale=70, sold on account=100 etc.

What problem i am facing is: I would like to Add Cash In Hand amount and would like to show it on my form. When day end I would like to move remaining cash In Hand on separate column of that date. The next day i would like to take the previous Remaining Cash in Hand as Cash In Hand at Start for next date and so on.

Please advice how can i accomplish it. Have I add a new table and do linking etc, or any other idea,

thanks and waiting of your response.

Rehan

 

[Ranman256]

I would envision a record
CoH, 7/20/15, $300

then the next day, get the record from yesterday, and append with todays date.
CoH, 7/21/15, $195

 

[Minty]

You shouldn't store a calculated value like this, as if you need to adjust anything it throws all the results you have stored out of the window.

The normal practice is to use a query to calculate the result when you need it, this way any adjustments are automatically accounted for.