View Single Post
  #1  
Old April 9th, 2010, 02:20 AM posted to microsoft.public.access.gettingstarted
Seano
external usenet poster
 
Posts: 10
Default How to show time for day's stock market high/low

I've set up a database of stock market intraday data going back two years,
showing Open/High/Low/Close data for every one minute bar of the day. I'm
trying to find 1) the high and low of each day, and 2) the times they
occurred.

Using: Date By Day: Format$([Stock Data].[Date],'yyyy.mm.dd') I can find the
Max of High and Min of Low to give me the day's high and low, but how do I
find the minute these occurred (there may be more than one, so if only one
could be displayed, the first occurence would be best ).

Many thanks