I have the following code:
SELECT DISTINCTROW tbl_charges.Carrier, tbl_charges.[Patient First], tbl_charges.[Patient last], tbl_charges.[Patient Account], tbl_Ins_Fee.[Network Name], tbl_Ins_Fee.[Research Text], tbl_charges.[Trans Date], tbl_charges.[Procedure QC], tbl_Ins_Fee.Modifier, tbl_Ins_Fee.[Allowed Amount], tbl_charges.[Charge Amount], tbl_charges.[Paid Amount], tbl_charges.Physician
FROM tbl_Ins_Fee RIGHT JOIN tbl_charges ON tbl_Ins_Fee.[Service Code] = tbl_charges.[Procedure QC];
It give me repeated data, not repeated records for the Charge amount, paid amount, etc. Is this enough data for you to look at??? I'd apreciate any help......
Max
Bookmarks