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;