It looks like you are committing spreadsheet (designing a spreadsheet).
Consider:
Code:
tblTests
-------------------
TestID_PK (Autonumber)
TestNo
TestDate
TestLineNo (Two Lines only)
tblResults
------------------
ResultsID_PK (Autonumber)
TestID_FK (Number - Long) (link to Tests table)
Product_FK (Number - Long) (link to products table)
PassFail_FK (Number - Long) (link to PassFail table)
Position (Number) (Pipe position)
ProductionDate
tblProducts
---------------
Product_PK (Autonumber)
ProductDesc (Text)
tblPassFail
------------
PassFail_PK (Autonumber)
PassFailDesc (Text)
(Records would be:
1 = Pass/No Leak
2 = Fail/Leaked)