Re: how to minus specific product.....
Actually I am trying to do a stock inventory access database, I would like make it in below method..
barcode	model	Computer balance	Physical balance	Variance  qty	Variance amount
22222	Abc	50	25	-25	-####
55555	Def	20	20	0	0
44444	Ghi	40	0	-40	####
33333	jkl	30	30	0	0

When inventory time we cannot count same goods all at a time, I mean for example according to above table 22222 barcode items may be we can find many place like shelf 1, shelf 2 or display. So, if I entry barcode like below form, it should show in main form like above form.  Please help how to sort or any method for it done.

barcode	model	Physical balance
22222	Abc	5
22222	Abc	18
22222	abc	2
33333	jkl	8
33333	Jkl	22
55555	Def	20



Thankyou 
Alex_raju

Re: how to minus specific product.....
===

Actually I am trying to do a stock inventory access database, I would like make it in below method..
barcode	model	Computer balance	Physical balance	Variance  qty	Variance amount
22222	Abc	50	25	-25	-####
55555	Def	20	20	0	0
44444	Ghi	40	0	-40	####
33333	jkl	30	30	0	0

When inventory time we cannot count same goods all at a time, I mean for example according to above table 22222 barcode items may be we can find many place like shelf 1, shelf 2 or display. So, if I entry barcode like below form, it should show in main form like above form.  Please help how to sort or any method for it done.

barcode	model	Physical balance
22222	Abc	5
22222	Abc	18
22222	abc	2
33333	jkl	8
33333	Jkl	22
55555	Def	20



Thankyou 
Alex_raju
