How to Display Singular or Plural Forms of Words Based on a Value in Microsoft Access

Поділитися
Вставка
  • Опубліковано 19 вер 2024
  • In this Microsoft Access tutorial I will teach you how to display the singular or plural form of a word (or a different word altogether) based on some value and whether it's 1 or not 1. We'll use the IIF function.
    BECOME A MEMBER:
    UA-cam: / @599cd
    or My Site: 599cd.com/THMe...
    LEARN MORE:
    599cd.com/Plural
    PREREQUISITES:
    Calculated Fields: 599cd.com/Calc...
    Concatenation: 599cd.com/Concat
    IIF Function: 599cd.com/IIF
    RECOMMENDED COURSES:
    Access Expert Courses: 599cd.com/Acce...
    USAGE:
    DogMsg: [NumDog] & " " & IIf([NumDog]=1,"dog","dogs")
    FREE TEMPLATE DOWNLOADS:
    TechHelp Free Templates: 599cd.com/THFree
    Blank Template: 599cd.com/Blank
    Contact Management: 599cd.com/Cont...
    Order Entry & Invoicing: 599cd.com/Invo...
    More Access Templates: 599cd.com/Acce...
    ADDITIONAL RESOURCES:
    FREE Access Beginner Level 1: 599cd.com/Free1
    How to Use Access in 30 Minutes: 599cd.com/30Mi...
    $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/Tech...
    Consulting Help: 599cd.com/DevNet
    Twitter: / learningaccess
    en.wikipedia.o...
    products.offic...
    microsoft.com/...
    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, singular, plural, iif, number of dogs
    QUESTIONS:
    Please feel free to post your questions or comments below. Thanks.

КОМЕНТАРІ • 2

  • @Hrubicundus
    @Hrubicundus Рік тому

    Richard Rost is the one true Big Dog in the Access world. He's a thoroughbred Irish wolfhound, everyone else is a yappy little Yorkshire terrier.

    • @599CD
      @599CD  Рік тому +1

      Thank you very much