Conditional Display of Company or Person Name in Microsoft Access, Part 2

In this Microsoft Access tutorial, I will show you how to conditionally display either a company name or a person's name using queries, calculated fields, and key functions like IsNull and string concatenation. This is part 2.

BECOME A MEMBER:

LEARN MORE:

PREREQUISITES:

LINKS:

RECOMMENDED COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, conditional display in Microsoft Access, company or person name in Access, Microsoft Access calculated fields, string concatenation in Access, IsNull function usage, Microsoft Access if function, query design in Access, creating calculated fields in Access, Access report customization, Nesting if functions in Access, using CanShrink in Access reports, Access string manipulation, Access report layout tips

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[Shadow.Dragon]

Thanks for the great video series, Richard! Lots of good "tips and tricks"!

[vitom]

Couldn't you put the IIF statement in the field on the report? I've done stuff like this in reports.