I have the following Dsum in a subform:
ojID]=" & Nz([ProjID],0))
Wouldnt this Sum all USDEquiv for ProjID = ProjID?
USDEquiv is a calculated field (see pic). the Dsum is not summing and only thing I can think of is USDEquiv is a calcualted field and not a field in tblFXRates. The ProjID's are populated.
here is the calcualted field as shown in the pic: