Pulling the first 60 hours based on sequenced order

[jersey417]

Hello all,

I'm running into a problem with a recent query design. I'm kind of stumped on how to proceed.

I'm trying to select the first 60 planned_hours of each of the first_resources.(HASN and CRT2) However, I only need the first 60 hours based on their sort_sequence order(ascending order) Since taken the images below I discovered that the planned hour field is in text rather then time so please disregard <=(now())+(60/24)

Current Design

Current output

Any help would be appreciated.

 

[jersey417]

n/m I figured it out by creating a running sum on planned hours

Thanks - this post can be deleted.