Help in select Query

Hi Everyone,
I have a table with six date fields, when the user enters data in the form The database populates with TextBox values. Some fields could be null.
My question is how to obtain the last NOT NULL Value from the table Row.
For Example:
Date1 Date2 Date 3 .........
------ ------ -------
Value1 Value2 Value3 .........

if Value3 is NULL I want to get Value2.
I'm not using Stored procedures.

Thanks in advance

Hi,

I am not sure what you need, but you might be able to use something like this:

hope this helps