gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,347
- Office Version
- 365
- Platform
- Windows
I have several DSUM fields on a form. The fields are looking for values from a Query:
=DSum("MONTH0_Active","qry_OnTimeDelivery_MetricData")
But unless I have the query open at the same time as I have the Form open, I don't get values. How can I get this to calculate without having to open the query - or is that not possible?
=DSum("MONTH0_Active","qry_OnTimeDelivery_MetricData")
But unless I have the query open at the same time as I have the Form open, I don't get values. How can I get this to calculate without having to open the query - or is that not possible?