Forum Discussion

SandraleeOster's avatar
SandraleeOster
Qrew Trainee
3 years ago

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

Hi, I have a member table which is the parent table to reports.  I also have a draw dates table that is a grandchild of member table and child to reports.  What I need is a report that gives me the...
formula queries
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
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's avatar
SandraleeOster
Qrew Trainee
3 years ago
That worked!  Thank you!!!

------------------------------
Sandralee Oster
------------------------------