- Sep 19, 2005
DSum("[Today]","[My]","[SpecificAlloc] = """ & [SpecificAlloc] & """") works and gives me the amount in the TodayField field of the My query for the SpecificAlloc field value that matches the current query's record. What if I want to add an additional field, [SpecificAlloc2] and match it the same way (i.e. two conditions)? I tried variations of the above but the syntax is too tricky.