Forum Discussion

LoganLott2's avatar
LoganLott2
Qrew Member
5 years ago

Is there anyway to select the record with the latest date of the group and show it in a report?

I have a set of records that have a date field and are part of different groups. Is there anyway to select the record with the latest date of the group and show it in a report? So instead of 12 groups...
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
np,
Make a report of type "Summary" (ie not a table Report)

Summarize Date by Maximum and Group by "Group".

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • LoganLott2's avatar
    LoganLott2
    Qrew Member
    5 years ago
    Ah got it. Thanks Mark

    ------------------------------
    Logan Lott
    ------------------------------