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.

Members

There is no extended cut, but here is the file download:

•  File Download - Gold Members

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!

Prerequisites

• Calculated Fields
• IIF Function
• DatePart

Links

• Fiscal Sort
• Weekday
• Nz
• Switch

Recommended Courses

• Access Expert 25

Notes

• Choose(N, "★☆☆☆☆", "★★☆☆☆", "★★★☆☆", "★★★★☆", "★★★★★")

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Merch Store - Get your swag here! Questions? Please feel free to post your questions or comments below or post them in the Forums.

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, 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