Dsum syntax help again, this forum is always the best place to go

[sheetspread]

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.

 

[Norie]

Try this untested expression.

DSum("[Today]","My","[SpecificAlloc] = '" & [SpecificAlloc] & "' Or [SpecificAlloc] = '" & [SpecificAlloc2] & "'")

This is a valid expression but it might not be what you want, which isn't actually clear.

 

[sheetspread]

Yes, that works! Thanks Norie. Sorry about not being clear enough, despite a reasonable effort. Sometimes my tries are outside the lines.......