Speeding up this Loop? (1 Viewer)

[WayneRyan]

Hascons,

Glad to hear it works well. You have to be very wary of using recordsets.

btw,

I think you should look very carefully about your usage of the FIRST and LAST
functions. I don't think that they do what you are expecting.

In my mind, you need a subsequent query to get the opening and closing
prices.

Wayne