hi, i have made stock control spreadsheets in excel. i want to make simple db in access.
db should be as
receipts issue and balance. for example i have a,b,c,d,e,f,g,h in stock and i have 1, 2, 3... projects in which either some of a to h are used or all a to h are used. after issuing a to h, how can i get the balance, the how many a's, b's.... are still in stock. and after receipt of a's, b's.... balance should be increased by that qty. any help will be appreciated.
thanks in advance.
db should be as
receipts issue and balance. for example i have a,b,c,d,e,f,g,h in stock and i have 1, 2, 3... projects in which either some of a to h are used or all a to h are used. after issuing a to h, how can i get the balance, the how many a's, b's.... are still in stock. and after receipt of a's, b's.... balance should be increased by that qty. any help will be appreciated.
thanks in advance.