Hi Everybody,
I'm using the following expression to find the sum of the current month sales.
=DSum("[Price]*[Quantity]","QueryCurrentMonth Sales","[ORDDate]=Month (now())")
However, it returns no result. Can anyone help please. Thank you.
Note: the above expression is located on the control...