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