These are "exploding BOM samples"

http://www.mvps.org/access/modules/mdl0027.htm

http://www.mvps.org/access/queries/qry0023.htm

But it's not completely clear what you requi From your
description, you just want to be able to look up a single
part in a part number table, and add % to the cost? That's
not a template: it's a query using the filter button on the Access
menu.

(david)


"Egan" wrote in message
...
Hi. I need an Access (or maybe Excel) template to help me create bills of
materials. A worksheet with a list of items (record) with the fields "Part
number", "description" and "cost". I then need to be able create a BOM by
entering the "part number" and have the "description" and "cost" as well
as
"selling price" (cost + profit %) calculated.

Thanks in advance. Chris.