Most Recent Record??
I have a Parent named Vehicles, and a Child name Monthly Vehicle Report that is completed monthly and includes a field called miles. I need to create a report totaling miles driven for the month....
Forum Discussion
Am I getting the maximum record ID or the maximum mileage?
------------------------------
Ermias Bean
------------------------------
------------------------------
Ermias Bean
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendI guess because it's a number, yes, you could get the maximum mileage and then get the 2nd highest Mileage, assuming that do provide a Mileage each report.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Yes there is a mileage field. OK, making edits
------------------------------
Ermias Bean
------------------------------- So my filter for the 2nd most recent mileage summary field would be "2 most recent mileage" is less than "1 most recent mileage"?
------------------------------
Ermias Bean
------------------------------- MarkShnier__Youyes, exactly.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------