Hi,
I have a report based on the sql query below but unfortunately the instead of just showing 2 lines it shows 4. The results are doubled. I checked the tables and they only have 2 lines each which is correct. If I remove tblPolIns.InsComm and [insprem]*[InsComm]/100 AS CommAmt from the query below, I get 2 lines (which is what I want). The tables seem to have the correct info.
I would really appreciate it if someone can point me in the correct direction in order to get this resolved.
SELECT DISTINCT tblAllPols.ClientNo, tblAllPols.FirstName, tblAllPols.LastName, tblAllPols.PolicyNo, tblAllPols.InvNo, tblAllPols.Issuedate, tblAllPols.InvDate, tblAllPols.Premium, tblAllPols.Tax, tblAllPols.Total, tblAllPols.Insurer, tblPolIns.InsShare, tblPolIns.InsComm, [insprem]*[InsComm]/100 AS CommAmt, tblAllPols.Currenc, tblAllPols.premium*[InsShare]/100 AS insprem, [insprem]+[instax]-[commamt] AS InsPremium, IIf([insprem]<>0,IIf(tblallpols.tax<>0,[tblallpols.tax]*[insshare]/100,0),tblallpols.tax) AS instax
FROM tblAllPols INNER JOIN tblPolIns ON (tblAllPols.PolSeqNo = tblPolIns.PolicySeqNo) AND (tblAllPols.ClientNo = tblPolIns.ClientNo) AND (tblAllPols.PolicyNo = tblPolIns.PolicyNo)
WHERE (((tblAllPols.InvNo)=46418));
Regards
Toukey
Tidak ada komentar:
Posting Komentar