[AccessD] SubQuery Help???

Howzabout:

SELECT ID, Date, Amount
FROM MyTable
WHERE Date Between [A-Date] And [B-Date]
AND Amount = 
  (SELECT Max([Amount])
  FROM MyTable
  WHERE Date Between [A-Date] And [B-Date])

-----Original Message-----
From: Mark A Matte [mailto:markamatte at hotmail.com]
Sent: Saturday, January 24, 2004 2:17 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] SubQuery Help???


Hello All,

I'm having a brain cramp...I have a table with 3 fields: ID, Date, Amount.  
I'm pulling the records between A-Date and B-Date...from these records I 
need the date where the Amount is greatest...can someone refresh my 
memory...

Thanks,

Mark

--------------------------------------------------------------------------------------------------------------------
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed.
If you have received this email in error please notify the
originator of the message. This footer also confirms that this
email message has been scanned for the presence of computer viruses.

Any views expressed in this message are those of the individual
sender, except where the sender specifies and with authority,
states them to be the views of Tappe Construction Co.

Scanning of this message and addition of this footer is performed
by SurfControl E-mail Filter software in conjunction with 
virus detection software.