Frances L (10/29/2008)

---

I have table in MS ACCESS:

has hire_date, rehired_Date, Termination_Date.


I want to

select rehired_date as hire_date when terminate_date

How to write this statement ?

ig:

hired_date as 10/1/07
termination date 10/03/07
rehired_date 10/2/08

then the hired_date will outcome as 10/02/08

hired_date as 10/1/07
termination date 10/02/07
rehired_date null

then the hired_date will outcome as 10/01/07


hired_date as 10/1/07
termination date 10/03/07
rehired_date is 10/02/07

then the hired_date will outcome as 10/02/07

Thx.

select isnull(rehired_date, hired_date) from sometable