I'm using the following code in a query but can't seem to get what I need...
Date: IIf(Not IsNull([Manalysisdate1]),[Manalysisdate1],IIf(Not IsNull([Manalysisdate2]),[Manalysisdate2],IIf(Not IsNull([Manalysisdate3]),[Manalysisdate3],IIf(Not IsNull([Manalysisdate4]),[Manalysisdate4]))))
Thanks...
if it looks like this, use Manalysisdate4
if it looks like this, use Manalysisdate3
if it looks like this, use Manalysisdate2
if it looks like this, use Manalysisdate1
Date: IIf(Not IsNull([Manalysisdate1]),[Manalysisdate1],IIf(Not IsNull([Manalysisdate2]),[Manalysisdate2],IIf(Not IsNull([Manalysisdate3]),[Manalysisdate3],IIf(Not IsNull([Manalysisdate4]),[Manalysisdate4]))))
Thanks...
if it looks like this, use Manalysisdate4
Manalysisdate1 | Manalysisdate2 | Manalysisdate3 | Manalysisdate4 |
text text text | text text text | text text text | text text text |
if it looks like this, use Manalysisdate3
Manalysisdate1 | Manalysisdate2 | Manalysisdate3 | |
text text text | text text text | text text text | |
if it looks like this, use Manalysisdate2
Manalysisdate1 | Manalysisdate2 | | |
text text text | text text text | | |
if it looks like this, use Manalysisdate1
Manalysisdate1 | | | |
text text text | | | |