Value Brought Forward

[Shafique]

Hello Everyone.
i have a table about goods production where i store daily production shift wise e.g
tbl_prd
ID Date Shift B_F production_Qty Transfer Balance
01 01-01-21 DAY 100 211 178 133
02 01-01-21 Night 133 181 210 104
03 02-02-21 Day 104 200 204 100

So How to i get previous record's balance value in B_F filed
i store one shift data in one record.

 

[JonXL]

So How to i get previous record's balance value in B_F filed
i store one shift data in one record.

You don't. As a general rule, if the value can be predicted/calculated from data already in the table, you don't store it.

That might be different if the value is difficult to calculate and you query more than enter data, but in this case I can't see it as worthwhile to save the value directly in the table...

 

[Micron]

Maybe this will help with a solution

Allen Browne - Inventory Control: Quantity on Hand

How do calculate the quantity-on-hand for inventory applications, rather than rely on a stored value.

allenbrowne.com

or if you must continue on current path you would need this to get the previous record, assuming you cannot simply use the date of the prior day. This would be complicated if the prior day date had no production because of a holiday or day off.
Subqueries