After reading several replies, I don't think I'm making clear what exactly it
is that I need.
Let me explain...
I have a database for warranty claims. We reimburse according to labor and
parts. For the parts section of the database, all I want is to be able to
enter any number such as "987978A1" along with its quantity, let's say 2 for
this example, and if on another claim someone else lists this same part with
a quantity of 1, I need to see a report saying:
PartNo Quantity
987978A1 3
However, I need to be able to enter more than one part number on each claim.
I have no way of narrowing down parts. Although I've used Access to build a
rather complicated database in the past, I'm no expert, but I would think
this would be rather simple. (A group of text boxes that stores in the same
field in a table.)
I really appreciate all the time everyone has put forth. Thanks for your
help,
Shannan
--
Message posted via http://www.accessmonster.com