Access: If I have a query can I sum the value of one of its fields on a Form?

[gheyman]

I have a Query "qry_OnTimeDelivery_MetricData" in the query I have a column named Month01_Active. That field has either a 1, 0 or nothing in it for each record. Can I create a Form and have a field on it that sums that column (Month01_Active)?

Thanks

 

[xenou]

a dsum function should work:

=DSum( [Month01_Active], [qry_OnTimeDelivery_MetricData], '[Month01_Active] = 1' )