Re: Query Involving Sums and Two Most Recent Dates

...

SELECT Consumer.*, Status.*, SUM(Hours.AppHours) AS TotalHours 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) AND Status.Type = "Approved"

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

Also appears to require a GROUP BY clause.

Thanks.

Ken