Re: Query Involving Sums and Two Most Recent Dates

At 02:33 PM 6/21/2018, you wrote:

I mean specifically, which records (consumer PK and apphours) would you expect in your results?

There are two Consumers whose most recent (last) status is "Approved": Consumer PKs 1 and 3. The relevant Status records are Status PKs 2 (for Consumer 1) and 8 (for Consumer 3).

Of those two Consumers, only Consumer 3 has any Hours records at all. The value for Consumer 3's most recent (last) hours record is 12 (Hours record PK 4).

Thanks.

Ken