Hi,
Can someone help in a DSum function.
The following works
aa = DSum("[IncTotal]", "Income", "[mmyy] = '" & vmth & "' AND [IncCA] = & vt")
But when I want to add another AND statement it does not
aa = DSum("[IncTotal]", "Income", "[mmyy] = '" & vmth & "' AND [IncCA] = & vt" & " AND [Incyy] = vcy")
It's the last AND is giving me an error.
Thanks for any help
Peter
Can someone help in a DSum function.
The following works
aa = DSum("[IncTotal]", "Income", "[mmyy] = '" & vmth & "' AND [IncCA] = & vt")
But when I want to add another AND statement it does not
aa = DSum("[IncTotal]", "Income", "[mmyy] = '" & vmth & "' AND [IncCA] = & vt" & " AND [Incyy] = vcy")
It's the last AND is giving me an error.
Thanks for any help
Peter