Access SQL Question

From: Bilal (bilcan_at_hotmail.com)
Date: 10/16/04 

Date: 16 Oct 2004 03:03:39 -0700

   Hi I create this select but don't work because I can't send response of Max(Tx.[Hakediş Tarihi]) to SubQuery?

//------------------------------------------------------------
Select TX.[Proje Kodu], TX.[Hakediş No], Max(Tx.[Hakediş Tarihi]) as Tarih
  ( Select Hakedişler.[Hakediş Tutarı] from Hakedişler
    Where Hakedişler.[Hakediş Tarihi]=TX.[Tarih]) ) as HakTutar
>From [Hakedişler] as [TX]
   where TX.[Proje Kodu]=409
Group by TX.[Proje Kodu], TX.[Hakediş No]
//-------------------------------------------------------------

I am using Access 2000 on Delphi 5