I have a table with 12 date columns per record (D1 thru D12) and I want to select from each record, the max date of those columns (not the max of the records). I know:
select max(D1) from table1
will yield max of D1, but say I want D3 from record1, D1 from record2, etc (using the following example)
1, ,12-Apr-2007,24-Dec-2008, ,...
2,13-Sep-2009, , , ,...
MS Access 2007
December 4, 2009 7:59 AM
December 24, 2009 3:11 PM