Sub testoct12()
Dim xx As Single
xx = DSum("Freight", "Orders", "ShippedDate between #8/10/94# and #9/10/94#")
Debug.Print xx
End Sub
Sub testoct12()
Dim xx As Single
xx = DSum("Freight", "Orders", "ShippedDate >=#8/10/94# and ShippedDate <=#9/10/94#")
Debug.Print xx
End Sub
Sir,
Sir,DSum("Freight", "Orders", "ShippedDate between #8/10/94# and #9/10/94#")
Tried this too but getting results as "Error"
I reckon arnel has spotted your extra problemyour double-quote character is unusual:
Dsum("[Dep]","[ InterestTable]","[Tdate] Between #04/01/2021# and #03/31/2022#”)
Yes.. Dep is numeric field.then check your table, what is [Dep], is it numeric?
what about the table, the spelling is correct?
TDate is it date or does it exists?
i think there is a space after [ in InterestTable?