I'd use an IIF function:

=IIF(X=1,"Yes",IIF(X=2,"No","Unknown")

Nested IIF Functions

Thank you, sir.  That helped very much.

I know that we're not supposed to assume, but can I presume that this would work for translating a combo box to a report?  I have a combo box on my form that the user can rate the overall condition (Excellent, Good, Fair, Poor, Bad, N/A).  It stores as a number in my table, yada yada as above.

Can I use a nested IIF to translate that number back to (Fair, Poor, Bad, N/A)?  So, if I do this right, my coding would be:
=IIF(X=3,"Fair",IFF(X=2,"Poor",IFF(X=1,"Bad","N/A")))

Sure... but if it's something where you think you might add choices in the future, make it a related table.

YES!  It did work.  As Mr. Spock would say, "Fascinating."

My Finish Condition for the various elements is a table: 5=Excellent, 4=Good, 3=Fair, 2=Poor, 1=Bad, 0=N/A.  Then I used that table to create a combo box on each form, and store the selected value as an "X"Condition on each other table (Finish Condition of the roof, walls, doors, foundation, etc).  The hangup I had was converting that number value back to something useful to be included in the reports.

I feel like this database, this project, is building an onion.  There are so many layers to it.  I have about a 3/4" thick notepad where I have sketched out and detailed how all of the elements relate to each other, which forms generate which subforms, and so on.  It has had some frustrating moments, but this is fun!!

Yep. That's one way to look at it. :)

Beau another option / thought is to put the "5=Excellent, 4=Good, 3=Fair, 2=Poor, 1=Bad, 0=N/A" key on the report. Then just print the rating value to the side or underneath
I personally don't like to use nested IIF if there are more than 3 choices.  (personal choice)
If there are more than 3 I tend to use a Select Case.

Switch Tip

Switch Function