Im probably being pretty dumb here but I wonder if somebody can answer me this quickly.
Given a table with a number of date fields in it i.e.
DATE1 DATE2 DATE3 DATE4
They may or may not have any data entered for some or all fields and can also be NULL how would I run a query to loop through each record and display the value of the highest date present in a Fifth field like this.
DATE1 DATE2 DATE3 DATE4 HIGHESTDATE
I tried playing around with MAX etc but cant seem to get anywhere and running out of time.