Count the daily storage of various products, send out, and inventory on the day

wylock

How to calculate three fields: storage-issue + previous day inventory = same day inventory

wylock

Will everyone? I give more

wylock

Storage, dispatch, same-day stock

46513128

It is recommended to use SCAN ..... ENDSCAN, this will be much faster than using SQL statements, and the general posting is only within 1S.

lancelot0229

update table name set inventory of the day = storage-issue + previous inventory

aimar7357

For the general approach, the corresponding inventory must be directly modified every time it goes out of the warehouse and into the warehouse, that is, the inventory is dynamic.

dzt0716

Jack up for.

Andead

Can refer to: http://blog.csdn.net/Andead/archive/2008/02/12/2089163.aspx

jeffliu_wx

The general practice, as mentioned on the 5th floor, is to use current inventory instead of the concept of today’s inventory

However, some users will require inventory information for each day. This can only be recorded with a special table, otherwise it is really a temporary summary, which may not be ideal in terms of speed.

luckythename

what