Keeping total of items entered

[Shannan Casteel via AccessMonster.com]

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

[pietlinden]

Main form is based on Warranty Claim,
Child form 1 is based n Warranty Parts. (WP_ID(PK/Autonumber), ClaimID
(FK, refers to WarrantyClaim.ClaimID, PartNo, Qty)

Table of Parts (PartNo, Description,...)

Report....
you can use a totals query for this.

SELECT PartNo, Sum(Quantity) as Total
FROM tblWarrantyParts
GROUP BY PartNo
ORDER BY PartNo;

There are other ways of doing this, but I would build the tables first
and then use the wizards to create the subform and main form. It
should do most of it for you. Then change the textbox for the PartNo
in the WarrantyParts subform to a combobox. Set the rowsource to the
Parts table.