Query restriction

[Timothy Andrepont]

I have developed a simple query and it is giving me multiple listings for the same value. As a mater of fact exactly 11/record. This is because the query is searching over 11 tables.

How do I construct the query to yield a single result for main primary key = "Site_PS_ID"? I have attached a data base. "Qry_Test" shows the basic issue I am having.

I look forward to hearing back from you.

Timothy

 

[JHB]

You have to use DISTINCT in the query.
In the Property Sheet for the query set the Unique Values to Yes.

SELECT DISTINCT tblPS_Master.SIte_PS_ID, Qry_01_Count_Sum.BS_Cat_Sum, Qry_01_Count_Sum.[BS_Cat_S/Count*W]
FROM tblPS_Master INNER JOIN Qry_01_Count_Sum ON tblPS_Master.SIte_PS_ID = Qry_01_Count_Sum.SIte_PS_ID;

But you have to modify the query "Qry_01_Count_Sum" for the field "BS_Cat_S/Count*W" so that it return a value. Just now it return "#Num!" for some records.