Richard:
In regard to the DSUM function, you showed an example of how to show sales for the last 30 days. I also want to see the total sales for the current year. I did some investigating and found the following solution:

=DSum("LineTotal","MenuMainF_CurrentMonthsSalesTotalQ","OrderDate>=DateSerial(Year(Date()), 1, 1)")

I hope this solution helps other users.

Steven S.
Berkeley, CA USA

---

Reply from Richard Rost:

Looks good. Thanks for sharing.