Display variable data

Posted on 2011-04-26
Last Modified: 2013-11-28
I have the below in a report:

=(RTrim([TABLE1_CITY]) & ", " & [TABLE1_STAT_CODE] & "  " & [TABLE1_ZIP])

For the last line, most addresses with show "United States of America".  However, a small few will show some other nation like Canada.  How can I make it display the nation only when it is a country other then "United States of America".  If it is "United States of America", show blank.
Question by:kkempen00
    LVL 30

    Accepted Solution

    In general:

    =IIf(Trim([TABLE2_NATION])="United States of America","",Trim([TABLE2_NATION]))

    Author Closing Comment

    Thank you!
    LVL 30

    Expert Comment


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now