I need help with a simple expression in a query

[quinto via AccessMonster.com]

If "NewStart" is null then "StartTime"
I searched but I did see anything that I could use.

Thanks

Quinto

 

[Daniel Pineault]

I'm not sure if I understand properly, but have you looked into the iif().

Maybe something like

iif(isnull([NewStart]),[StartTime],[NewStart])

--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Ken Snell \(MVP\)]

Or
Nz([NewStart], [StartTime])

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

I'm not sure if I understand properly, but have you looked into the iif().

Maybe something like

iif(isnull([NewStart]),[StartTime],[NewStart])

--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

If "NewStart" is null then "StartTime"
I searched but I did see anything that I could use.

Thanks

Quinto

 

[quinto via AccessMonster.com]

Thank
both suggestions are working fine

Quinto

Or
Nz([NewStart], [StartTime])

I'm not sure if I understand properly, but have you looked into the iif().

[quoted text clipped - 8 lines]