On Sat, 10 Apr 2010 03:23:01 -0700, Seano
wrote:

Original code would hang but I finally got this to work:

SELECT [Date], [Time], [High]
FROM [TestTable]
WHERE [High] =
(SELECT Max([TestTable].High)
FROM [TestTable] AS T
WHERE T.[Date]=[TestTable].Date);

An alternative would use a Top Values subquery:

SELECT [Date], [High], (SELECT TOP 1 X.[Time] FROM tablename AS X WHERE
X.[Date] = tablename.[Date] ORDER BY X.[High], X.[Time] DESC) AS TimeOfHigh,
[Low], (SELECT TOP 1 X.[Time] FROM tablename AS X WHERE X.[Date] =
tablename.[Date] ORDER BY X.[Low] DESC, X.[Time] DESC);

--

John W. Vinson [MVP]