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:
599cd.com/DSum
PRE-REQUISITES:
DLookup: 599cd.com/DLookup
RECOMMENDED COURSES:
Access Expert 11: 599cd.com/ACX11
LINKS:
Date Criteria: 599cd.com/DateCriteria
Concatenation: 599cd.com/Concat
Dashboards: 599cd.com/Dashboards
NZ Function: 599cd.com/nz
Aggregate Query: 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 KZitem doesn't allow them in their description fields.
BECOME A MEMBER:
KZitem: / @599cd
or My Site: 599cd.com/THMember
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
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.
Негізгі бет DSum Function with Multiple Criteria in Microsoft Access to Calculate Previous 30 Days Sales Totals
Пікірлер: 12