Forum Discussion

LoganLott2's avatar
LoganLott2
Qrew Member
4 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 with 10 records each. I only see 12 groups with 1 record each.

------------------------------
Logan
------------------------------

2 Replies

  • 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
      Ah got it. Thanks Mark

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