Skip to main content
Question

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

  • February 18, 2022
  • 0 replies
  • 83 views
Forum|alt.badge.img+5
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement