Forum Discussion

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

Qrew 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

Qrew Trainee

3 years ago

That worked! Thank you!!!

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