Assuming that there is no Parent table for these record which is by day, I would go into excel and load up all the days for the next 20 years.
Then import into a table of Days, where the key field is set to the Date.
Then make a relationship where 1 Day has many Records (ie the Summary table) and let it create a field for the relationship called Related Days. The edit that field and make it be a formula equal to the date field in your Records table. The reason for that is to preserve the behaviour of the calendar on the data entry form for the Date field in Records.
Then make a summary of the Max Record ID# called [Record ID# of Last Record for this day].
Then lookup that field [Record ID# of Last Record for this day] down to Records.
Then lastly filter the Summary report where
[Record ID#] is equal to the value in the field [Record ID# of Last Record for this day]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
