I have no idea how to do this:
I want to have a form in which a user enters a specific serial number, and all items from the inventory with that serial number appear. I would then like the form to calculate and display the sum of one aspect of all of the items.
Any ideas?
P.S. I'm pretty new to access, but VBA does not scare me