Creating a formula query to get most recent date and the results from that date

Question

Hi,I have a member table which is the parent table to reports.&nbsp; I also have a draw dates table that is a grandchild of member table and child to reports.&nbsp; What I need is a report that gives me the latest draw for the member and the result of that draw.&nbsp; Is there a way to get this information without making a direct relationship between member and the draw dates table?Thank you,Sandy------------------------------Sandralee Oster------------------------------

markshnier__you · Answer

Sure, the correct way to do this is that is to create Summary fields on Reports to get that Draw information up a level. Then another couple of summary fields to summarize those up from Reports to Members. So a "double hopper" to get up two levels.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

sandraleeoster · Answer

That worked!&nbsp; Thank you!!!------------------------------Sandralee Oster------------------------------

Forum Discussion

Creating a formula query to get most recent date and the results from that date