Newbie help.

I am new to access so please bear with me.

I have two tables.
Table #1 has "part #", "description", and "price".
Table #2 has "assembly #", "description", "Part #1" (picked from table 1),
"Part #2" (picked from table 1), "Part #3" (picked from table 1), "Part #4"
(picked from table 1).

I want to sum up the cost of an assembly and am completely stumped. I can't
seem to connect "Part #x" with "price". I would be forever grateful and
would consider naming a child after the person that can solve this very
simple problem for me.


.

Relevant Pages

  • Re: DELL goes down hill.
    ... PA Bear wrote: ... > Would you be willing to pay $100 or more for this? ... Why would it cost $100 more to supply a real CD over the different ... Prev by Date: ...
    (microsoft.public.windowsxp.general)
  • Re: RiDE textile suit test
    ... dwb says... ... > Bear wrote: ... So far you've cost me £7. ... Prev by Date: ...
    (uk.rec.motorcycles)
  • RE: nested sumif or sumif with two criteria
    ... was the exact same thing. ... >> color and third is cost. ... I am trying to create a formula that will sum all ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • all values less than 0 to equal 0 or null
    ... I am trying to calculate the sum of the cost but the data I have has negative ... negative values equal zero or not be counted at all when I make cost grouped ... Prev by Date: ...
    (microsoft.public.access.queries)
  • How to add equal values and than replace them with their sum?
    ... I wonder if Excell could even do something like this. ... values and their respective cost in. ... replace these values with their sum and possibly delete used lines ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)