طراحی کوئری ها قدری تغییر میکنه و گروه بندی رو بر اساس کدناحیه (بجای ناحیه) انجام میدیم که اصولی تر هست.
/* EBLAGH_PROJECT_KOL */
SELECT TblSabt.IDNahi, Count(TblSabt.NumPro) AS PEK
FROM TblSabt
WHERE (((TblSabt.Pol)>0))
GROUP BY TblSabt.IDNahi;
/* TAHVIL_PROJECT_SAL */
SELECT TblSabt.IDNahi, Count(TblSabt.NumPro) AS PTS
FROM TblSabt
WHERE (((TblSabt.Pol)>0) And ((TblSabt.Emtiaz)>0) And ((TblSabt.Sal)=TEMPVARS!SAL))
GROUP BY TblSabt.IDNahi;
/* AMALKARD_PROJECT_KOL */
SELECT EP.IDNAHI, EP.PEK, TP.PTK, [TP].[PTK]/[EP].[PEK] AS PAK, [NAVAHI].[VAZN]*[PAK] AS PAWK
FROM (EBLAGH_PROJECT_KOL AS EP INNER JOIN TAHVIL_PROJECT_KOL AS TP ON EP.IDNAHI = TP.IDNAHI) INNER JOIN Navahi ON EP.IDNahi = Navahi.IDNahi;
/* AMALKARD_PROJECT_SAL_ROTBE */
SELECT A.IDNAHI, A.PES, A.PTS,
A.PAS, (SELECT COUNT (*)+1 FROM (SELECT PAS FROM AMALKARD_PROJECT_SAL) AS B WHERE A.PAS<B.PAS) AS PRS,
A.PASW, (SELECT COUNT (*)+1 FROM (SELECT PASW FROM AMALKARD_PROJECT_SAL) AS B WHERE A.PASW<B.PASW) AS PRSW
FROM AMALKARD_PROJECT_SAL AS A;