Hi,
I am re-writing an application that used access as the backend.
I am using t-sql.
I have a query with this line, and I would just like to know the best way to convert it to sql.
CCur(Format(DSum("[Amount]","Line_Item_Payments","ChargeID=" & [Charges].[ID] & " AND Type =" & 4),"#,##0.00;;;0.00")) AS PC
Basically it looks in Line_Item_Payments for every charge in Charges and totals it by type.
I have been working with this query for a bit and have been unable to have workable results come from it.
Please help,
-Edward
I am re-writing an application that used access as the backend.
I am using t-sql.
I have a query with this line, and I would just like to know the best way to convert it to sql.
CCur(Format(DSum("[Amount]","Line_Item_Payments","ChargeID=" & [Charges].[ID] & " AND Type =" & 4),"#,##0.00;;;0.00")) AS PC
Basically it looks in Line_Item_Payments for every charge in Charges and totals it by type.
I have been working with this query for a bit and have been unable to have workable results come from it.
Please help,
-Edward
