porque no me funciona esta consulta,sacar el maximo siempre siendo la fecha la mas actual

karkos
03 de Enero del 2004
SELECT t1.ibex_35,t1.d_jones,t1.sp500,t1.nasdap, t1.[ibex_35],t1.[d_jones],t1.[sp500],t1.[nasdaq] , max(t1.fecha) AS máxdefecha
FROM [indice1] AS t1
WHERE (((t1.ibex_35,t1.d_jones,t1.sp500,t1.nasdap) In (select max(t2.ibex_35,t2.d_jones,t2.sp500,t2.nasdap)
from [indice1] as t2
where t1.ibex_35,t1.d_jones,t1.sp500,t1.nasdap=t2.ibex_35,t2.d_jones,t2.sp500,t2.nasdap)))