By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,945 Members | 1,540 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,945 IT Pros & Developers. It's quick & easy.

Update

P: 64
Hi...can anyone help me for this case...I have create stock system...and using one of the update query in access..The problem is when I put the quantity needs for example, I put quantity needs as 5 then it will deduct from 45 based on the main quantity 50...then, when I put 4 at quantity received the main quantity will be 49...and the problem is when I put back 5 in quantity received at the main quantity it will become 44..how I can manage to deduct it, however I put the quantity needs 5 and the main quantity is 50...and however i put the qty received to 4 or 3 or 2...it's still hold the main quantity data..
Apr 21 '15 #1
Share this Question
Share on Google+
1 Reply


jforbes
Expert 100+
P: 1,107
I think you will need to show us your code/SQL before anyone can effectively help you.
Apr 21 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.