I am hopeful that someone here would be able to help me. I am rather new to Access.
I have two tables the product file table and the packaging component table. Pnum (product number is a primary key in both tables) ComponentPNum is also a primary key in the packaging component table.
What I am trying to do is look up the cost of DrumNum by matching the DrumNum to the Pnum in the same table.
SELECT PRODFIL2.PNAME1 AS [Product Name], PRODFIL2.PNUM AS [Product #], PRODFIL2.UP AS [Packaging Unit], PRODFIL2.DRMNUM AS [Container #], PRODFIL2_PackagingComponent.ComponentPNUM AS [Lid #], PRODFIL2.lcost AS [Container Cost]FROM PRODFIL2 INNER JOIN PRODFIL2_PackagingComponent ON PRODFIL2.[PNUM] = PRODFIL2_PackagingComponent.[PNUM]WHERE (([qryPackagingCost]![Container #]=[PRODFIL2]![PNUM]));