21 Jun
2018
21 Jun
'18
6:33 p.m.
I mean specifically, which records (consumer PK and apphours) would you expect in your results?
Example: 2, 12 and 3, 14
On 21 June 2018 14:28:10 GMT-04:00, Ken Dibble krdibble@stny.rr.com wrote:
At 02:21 PM 6/21/2018, you wrote:
What's your expected output from the data you presented?
Answer: 2 Approved Consumers, having a total of 12 Hours.
I did include that in my original post.
To make it a little easier for people to try to help, here's some code to build up the data and my attempt at what I've understood as your requirements:
[snip]
Thank you for doing that. Wow, I'm sorry I omitted that. I usually do that when I ask for help with queries.
Ken
[excessive quoting removed by server]