I have what is probably an easy question for most but searching for this
has turned into a nightmare.

Basically, I have a table as follows (many columns omitted):

ACTION_DATE QUANTITY
11/9/2004 9:08:20 AM 0
11/9/2004 10:23:40 AM 0
11/9/2004 10:23:41 AM 2
11/23/2004 11:20:20 AM 1
11/23/2004 11:20:24 AM 1
11/23/2004 11:20:25 AM 4
11/23/2004 11:20:25 AM 5

What I need to be able to do is select the quantity from last row
for each day given a date range.

Any help would be great.
Thanks.