Predmet:Re: Presmetka DPH (DDV) , (PDV) vo cod so popust

---

Mene mi treba nesto vakvo :

SQL_DDV = "SELECT A.DDV, Sum(A.Kolicina) AS KOL, Avg(A.Ed_Cena) AS Cena, tblTarifi.Koeficient, [kol]*[Cena] AS VUkupno, & VkupnaSuma & AS Suma, Avg(" & Rabat & ") AS Rab, [suma]-[rab] AS Za_Naplatu, [Suma]/[VUkupno] AS Procenat, [Za_Naplatu]/[procenat] AS N_Sa_Pdv, [N_Sa_Pdv]/[Koeficient] AS N_Bez_PDV, [N_Sa_PDV]-[N_Bez_Pdv] AS PDV_Iznos" _
& " FROM tblTarifi INNER JOIN (tblSmetki INNER JOIN tblsmetki_stavki AS A ON tblSmetki.ID_Smetka = A.Smetka_Br) ON tblTarifi.Tarifa = A.DDV" _
& " Where (((tblSmetki.ID_Smetka) =" & SmetkaBroj & "))GROUP BY A.DDV, tblTarifi.Koeficient;"

VkupnaSuma = vkupnata suma na racunot so PDV bez popust (Ovaa vrednos ja imam gotova ne mora da se presmetuva)
Rabat = Popustot na racunot ( Isto gotova vrednost)
SmetkaBroj = ID od Racunot za koj treba da se odnesuva rekapitulacijata