count needed

[Jurni]

I have a form created which has 25 fields for part names to be entered into. I need to get a count of how many of each part we are using. The name may be repeated several times. I do not know VBA, so I need a simple way to do this. I tried doing a pivot table, but I kept getting an OLE error. Any help would be greatly appreciated.

Thanks.

 

[Chris RR]

The problem is the structure of your data, not the form layout.

Can I assume that there is something that logically groups those 25 parts? Like maybe they are all on one order, or part of one larger machine?

You need to set up two tables, then. One would have the order number (or assembly number, or whatever...) as the key. The second table would have one record for each and every part on the order, and a quantity for that particular part. The key on the second table would be the order number AND the part number.

This lets you have one part per order (saving lots of space), or 147 parts per order (flexibility) and it is easy to join the tables, sum up the quantity, and get your answer.

This is a simplified explanation, but in general, if you get the information stored correctly, the rest is a lot easier.