Dear sir,

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

I don't see an problem doing what you want is you always calculate the balances from transaction records.


You would not have a record that look like this: barcode model Computer balance Physical balance Variance qty Variance amount

You would have transaction record to calculate the Computer balance and Physical balance.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015