DSUM Lookup on Table - with Filter
Posted on 2013-01-16
I have a form into which I'm using an "On Open" event. If the total for [In] table of the [Amt] field = 0, where grouped [Srce_Type] = "Lockbox", then perform an operation.
I know I could write a GROUP BY query to return the desired output but was hoping to filter and sum total in a simpler way.
Example: If DSum("[Amt]", "[In]", [Srce_Type] = "Lockbox") = "0" Then
Is there a simple VBA line which would perform this operation?