DSum Function with Multiple Criteria in Microsoft Access to Calculate Previous 30 Days Sales Totals

In this Microsoft Access tutorial, I will show you how to calculate the previous 30 days of paid and unpaid orders using the DSum function. We'll learn how to use it with multiple criteria as well. LEARN MORE: https://599cd.com/DSum PRE-REQUISITES: DLookup: https://599cd.com/DLookup RECOMMENDED COURSES: Access Expert 11: https://599cd.com/ACX11 LINKS: Date Criteria: https://599cd.com/DateCriteria Concatenation: https://599cd.com/Concat Dashboards: https://599cd.com/Dashboards NZ Function: https://599cd.com/nz Aggregate Query: https://599cd.com/Aggregate USAGE: DSum("OrderTotal","OrderT","OrderDate XXX= Date()-30") DSum("OrderTotal","OrderT","OrderDate XXX= #" & Date()-30 & "#") DSum("OrderTotal","OrderT","OrderDate XXX= #" & Date()-30 & "# AND IsPaid=TRUE") NOTE: I had to put XXX above to represent the less-than symbol because YouTube doesn't allow them in their description fields. BECOME A MEMBER: YouTube:    / @599cd   or My Site: https://599cd.com/THMember ADDITIONAL RESOURCES: FREE Access Beginner Level 1: https://599cd.com/Free1 $1 Access Level 2: https://599cd.com/1Dollar Donate to my Tip Jar: https://599cd.com/TipJar Get on my Mailing List: https://599cd.com/YTML Contact Me: https://599cd.com/Contact TechHelp: https://599cd.com/TechHelp Consulting Help: https://599cd.com/DevNet Twitter:   / learningaccess   https://en.wikipedia.org/wiki/Microso... https://products.office.com/en-us/access https://microsoft.com/en-us/microsoft... KEYWORDS access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, DSum Function, DSum(), ms access dsum multiple criteria, dsum function ms access, ms access vba sum function QUESTIONS: Please feel free to post your questions or comments below. Thanks.