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 latest draw for the member and the result of that draw.  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
------------------------------

2 Replies

  • 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
      That worked!  Thank you!!!

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