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

[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.

 

[strive4peace]

Hi Travis,

try this for criteria:

"DE_Account = '" & [DE_Account] & "'"


Warm Regards,
Crystal
remote programming and training

Video Tutorials on YouTube!
http://www.youtube.com/user/LearnAccessByCrystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*