How to join fields?

[offie]

This is what I have:


I want one field


Time
4
4
4
3
3
5
4
etc...

Each field in this query is coded as IIf([Timeliness5]=True,5,"") - probably not important. But I would like to be able to do this all in one query, not 2.

I've tried &, +, and joins but either I am not formatting it right or they just don't work,

Any Ideas?
Thanks!

Code:
SELECT [100DocumentsPhase].[Project Nmber],
IIf([Timeliness5]=True,5,"") AS Expr1,
IIf([Timeliness4]=True,4,"") AS Expr2,
IIf([Timeliness3]=True,3,"") AS Expr3,
IIf([Timeliness2]=True,2,"") AS Expr4,
IIf([Timeliness1]=True,1,"") AS Expr5
FROM 100DocumentsPhase;

[offie]

Nevermind, I was messing up something easy, it was:

SELECT [100DocumentsPhase].[Project Nmber],
(IIf([Timeliness5]=True,5,"") &
IIf([Timeliness4]=True,4,"") &
IIf([Timeliness3]=True,3,"") &
IIf([Timeliness2]=True,2,"") &
IIf([Timeliness1]=True,1,"")) AS Timeliness
FROM 100DocumentsPhase;

[RuralGuy]

Thanks for posting back with your solution. FYI: that table is not normalized. Not a good idea in an RDBMS.