Most Recent Record

Question

How do you filter a report to only display the most recent record?------------------------------Kimberly Massa------------------------------

markshnier__you · Answer

There any relationship involved? Is this a Child table to a parent record?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

kimberlymassa · Answer

I have created an automated table that creates records when they meet the assigned criteria which would be the child table.------------------------------Kimberly Massa------------------------------

markshnier__you · Answer

Are you looking for the most recent record in that whole table? Are these child records of a parent table where there's a relationship and you want the most recent child for each particular parent record?

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

kimberlymassa · Answer

I am looking for the most recent record in the child table created.&nbsp;I have a Parent Table that includes all types of records.I have a Child Table that only includes records that include injuries.I have created a formula field that displays the days since the last injury.This is only correct on the most recent Child Table record, this is the record that I want displayed in a report.------------------------------Kimberly Massa------------------------------

markshnier__you · Answer

Ok make a summary field of the most recent injury date.&nbsp;
Lookup down to injuries.Then make a report on the child table of records where the most recent injury date equals the injury date.You can also float up the text from the injury record up to the Parent record using a combined text summary field with a similar filter. &nbsp;It will appear in a bubble-like format, but you can make a new field of type formula text to convert it to a more familiar text format.ToText ([Combined Text Injury Name])------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Most Recent Record