troubleshooting Question

Increment Qty from Scan

Avatar of jspc
jspcFlag for Australia asked on
DatabasesMicrosoft Access
14 Comments2 Solutions84 ViewsLast Modified:
Hello,

I have the attached Microsoft Access Database with two columns:
•      UPC (Barcode)
•      Quantity

I want to be able to scan a barcode to the database. If the same barcode is scanned I want the qty of the first scanned line item to increment to 2 rather than creating a new line.

So I want to combine the Qty column (or Sum) if the same barcode is scanned.

Are you able to help me with that? The attached database can be changed.

Thank you.
StockCount.accdb
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros