In this Microsoft Access tutorial, I'm going to teach you how to find the maximum value from multiple fields in the same record.
Tabitha from Knoxville, Tennessee (a Platinum Member) asks: I have a table where I'm tracking quiz and test scores for my students. Every quarter they take 3 quizzes and 3 tests. Their grade is calculated by taking the average of the three tests and the largest grade from the quizzes. So let's say they got quiz grades of 80, 75, and 70, and then got 100s on all of their tests. Their final grade would be (100+100+100+80) / 4 = 95. My question to you is how can I determine the largest of the three quiz grades?
Silver Members and up get access to an Extended Cut of this video. Members will learn how to create a function so that you can send any number of values to it using something called a parameter array.
MEMBERS VIDEO:
• Max Value Different Fi...
BECOME A MEMBER:
KZitem: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
599cd.com/MaxValue
PRE-REQUISITES:
Calculated Fields: 599cd.com/Calculated
IIF Function: 599cd.com/IIF
LINKS:
Footer Totals: 599cd.com/FormFooterTotals
Aggregate Query: 599cd.com/Agg
DMax: 599cd.com/DMax
RECOMMENDED COURSES:
Arrays: 599cd.com/ACD21
Parameter Arrays: 599cd.com/ACD42
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
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, finding the highest value in different fields, find max value of different fields in same record, parameter array, paramarray, lbound, ubound, for each
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Негізгі бет How to Find the Maximum Value of Multiple Fields in the Same Record in Microsoft Access
Пікірлер: 11