DSum with multiple criteria

[silv0920]

Hi,

I have this DSum statement in my access query with 1 criteria but I need to add in another criteria. The other criteria is also in the same table. I don’t know how to include multiple criteria in the same DSum statement. This is what I have now:
YTD: Format(DSum("[Amount]","[TableName]","[Field1]<=" & [Field1]),"Currency")

Any help would be greatly appreciated.

Thanks!

 

[sheetspread]

Try:

DSum("[Field1]","TableOrQuery","[Field2] = '" & [Field2] & "' and [Field3] = '" & [Field3] & "' and [Field4] = '" & [Field4] & "'")

 

[silv0920]

Thanks so much!