|
||||||
Choose By Richard Rost ![]() ![]() Using the Choose Function for Value Selection In this Microsoft Access tutorial, I will show you how to use the Choose function in your queries to return different values based on an index, such as assigning category names depending on numbers or displaying star ratings. We will also compare the Choose function with other options like the If and Switch functions, and go over practical examples like fiscal quarter sorting, weekday codes, and customer order sizes. MembersThere is no extended cut, but here is the file download: Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today! PrerequisitesLinksRecommended CoursesNotes
KeywordsTechHelp Access, Choose function, calculated query fields, If function, DatePart function, fiscal quarter sorting, quarter renumbering, CustomerT, FamilySize, order size categories, Shift-F2 zoom, North South East West example, weekday abbreviation, Status ID mapping, Unicode rating stars, Switch function, inequalities, string functions, logical functions, math functions, type conversion, date time functions, aggregate functions, domain aggregate functions, financial functions
|
||||||||||||||||||||
| |||
Keywords: TechHelp Access, Choose function, calculated query fields, If function, DatePart function, fiscal quarter sorting, quarter renumbering, CustomerT, FamilySize, order size categories, Shift-F2 zoom, North South East West example, weekday abbreviation, Statu PermaLink Choose in Microsoft Access |