Researched & tried numerous approaches to solve the problem that I'm giving the experts to do for me, once again. I have a tbl_Job_Basics that I and need a query that merges it with data from these the [named fields] in these four tables; 'tblRevenue for the "Revenue" amount', 'tblMaterial for [Matl_Cost], [Sales_Tax], ['Sales_Tax]' & '[Del_Fee'], tbl'Labor' for[ Labor_Cost] & 'tblDump' for [Fee].
Here is my sql for incorporarting [Revenue] earned for various jobs, identified by 'J_ID'.
It produced the correct results, but when I join tblMatrial, tblLabor & tblDump to it, the data sheet contains duplicate data in fields that should be empty (ie, not all tables contain an equal number of records; like displaying two 'Job_Price' values from the tblJobs, when it should only be shown in the first row for a given J_ID.
q_Job_Bucks Revenue
SELECT q_Jobs_Basics.J_ID, q_Jobs_Basics.L_Name, q_Jobs_Basics.Percent_OH, q_Jobs_Basics.Percent_GnA, q_Jobs_Basics.Job_Price, q_Jobs_Basics.Status, tblRevenue.Biz_Date, tblRevenue.Revenue
FROM q_Jobs_Basics
RIGHT JOIN tblRevenue
ON q_Jobs_Basics.[J_ID] = tblRevenue.[J_ID];
Here is my sql for incorporarting [Revenue] earned for various jobs, identified by 'J_ID'.
It produced the correct results, but when I join tblMatrial, tblLabor & tblDump to it, the data sheet contains duplicate data in fields that should be empty (ie, not all tables contain an equal number of records; like displaying two 'Job_Price' values from the tblJobs, when it should only be shown in the first row for a given J_ID.
q_Job_Bucks Revenue
SELECT q_Jobs_Basics.J_ID, q_Jobs_Basics.L_Name, q_Jobs_Basics.Percent_OH, q_Jobs_Basics.Percent_GnA, q_Jobs_Basics.Job_Price, q_Jobs_Basics.Status, tblRevenue.Biz_Date, tblRevenue.Revenue
FROM q_Jobs_Basics
RIGHT JOIN tblRevenue
ON q_Jobs_Basics.[J_ID] = tblRevenue.[J_ID];