NauticalGent
Ignore List Poster Boy
- Local time
- Yesterday, 23:59
- Joined
- Apr 27, 2015
- Messages
- 6,632
I can across an issue yesterday where to PM wanted to measure the amount a time a Purchase Request Order Number (PRON) spent in the Process Point (Proc Point) of its life span.
After thinking on it and playing around, I remembered a similar issue I had and asked a question on this thread. Using the subquery approach, I was able to achieve my goal - took me some time and a whole lot of cussing, but I managed.
I attached a quick mock-up to demonstrate how I did it. Since I am in the process of improving the application, I will be altering the table to make this easier, but I wanted to show anyone who ventures here the power and utility of subqueries.
After thinking on it and playing around, I remembered a similar issue I had and asked a question on this thread. Using the subquery approach, I was able to achieve my goal - took me some time and a whole lot of cussing, but I managed.
I attached a quick mock-up to demonstrate how I did it. Since I am in the process of improving the application, I will be altering the table to make this easier, but I wanted to show anyone who ventures here the power and utility of subqueries.