Duplicating records

[Hope]

ok, I think I'm getting more confused if possible, the db in Post 7 is a simple query if all the information I need is in one table, the problem is I need everything in tblTest, I need Type_Name in lkpType, and I need Weig_Submerged and Weig_Dry in tblWeight, that is why I'm trying to link them all so I can pull all these fields in my report???

 

[KenHigg]

Report - ?

I seem to have lost the database you posted, can you repost it? I do you a down and dirty report...