reply the records on query

[digit]

i have that query
SELECT Premii.Npolica, Polici.ime_zastrahovasht, Polici.tarifa, Premii.pyrwogodishno, Polici.tip_zas, Premii.valuta, Premii.ozp, Premii.dzp_obshto, Vnoski.wstypitelni_vnoski, Vnoski.dialovi_vnoski, Vnoski.dopylnitelni_vnoski, Nz([ozp])+Nz([dzp_obshto])+Nz([wstypitelni_vnoski])+Nz([dialovi_vnoski])+Nz([dopylnitelni_vnoski]) AS SumaObshto, Premii.N_kvitancia, Premii.data_pr_zapri
FROM (Polici RIGHT JOIN Premii ON Polici.Npolica = Premii.Npolica) LEFT JOIN Vnoski ON Premii.Npolica = Vnoski.Npolica
WHERE (((Polici.tarifa)<>"ÅÏÑÈËÎÍ") AND ((Premii.pyrwogodishno)="äà") AND ((Polici.tip_zas)="èíäèâèäóàëíà") AND ((Premii.valuta)="BGN") AND ((Premii.data_pr_zapri) Between [ïúðâà äàòà] And [âòîðà äàòà]));
but when i have 2 records in Premii.ozp in one same month the query reply the same records for [wstypitelni_vnoski][dialovi_vnoski] and [dopylnitelni_vnoski] where i have only one records

 

[dynamictiger]

From the queries I have done that return false records the problem is invariably in the joins.

FROM (Polici RIGHT JOIN Premii ON Polici.Npolica = Premii.Npolica) LEFT JOIN Vnoski ON Premii.Npolica = Vnoski.Npolica

A Left Join is unusual perhaps try this as a right join, or alternatively both as left.