Re: Query Involving Sums and Two Most Recent Dates

On Thu, Jun 21, 2018 at 12:22 PM, Ken Dibble krdibble@stny.rr.com wrote:

Thank you, but I think I left out a requirement. The hours have to come from the most recent Hours records as well.

I should have realized that from your example solution. I *ASSuMEd* we were totalling hours. My bad.

SELECT Consumer.*, Status.*, Hours.AppHours FROM Consumer JOIN Status on Consumer.ConPK=Status.ConFK JOIN Hours on Consumer.ConPK=Hours.ConFK WHERE Status.Date = (SELECT MAX(Stat2.Date) FROM Status Stat2 WHERE Stat2.ConFK = Consumer.ConPK GROUP BY Stat2.ConFK) AND Status.Type = "Approved" AND Hours.Date = Status.Date