Access to Sql

edd1em

Active member
Joined
Jul 21, 2004
Messages
28
Programming Experience
3-5
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
 
Top Bottom