Dsum in Qry for total payments on an account for last 90 days

  • Thread starter Thread starter Travis
  • Start date Start date
T

Travis

I have a query which contains information on accounts for the prior 90 days
based on a table of claim information. I want to build a query that will
take total the payments made in the last 90 on accounts. All tables contain
DE_Account as a text field. I have a query built that works when I use this
formula:

Total_Payments: DSum("[Payment_Amount]","Qry_Rpt_TblPaymentInfo","DE_Account
= '861560621'")

When I try to make the DSum dynamic on DE_Account it fails:
Total_Payments: DSum("[Payment_Amount]","Qry_Rpt_TblPaymentInfo","DE_Account
= ' [Qry_Rpt_90_Day_Liquidation]! [DE_Account] '")

Qry_Rpt_90_Day_Liquidation is the query I am trying to build.
 
Back
Top