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
MarkShnier__You
Qrew Legend
Qrew Legendnp
You have already made a summary field of the Maximum Record ID# and looked it up back down to the child record. Let's name that Record ID# of 1st most Recent Monthly Report.
Now make another Summary field (duplicate that one if you like) and make it subject to the filter that the Record ID# is less than the Record ID# of most Recent Monthly Report, call that the Record ID# of the 2nd most Recent Monthly Report. That is like saying not counting Usain Bolt, who won the last 100 dash at the last Olympics, and of course the answer would be Justin Gaitlin, who "won" if you don't count Usain Bolt being there ahead of him 0.08 seconds ahead.
Then you can summarize up the mileage for respectively the 1st Most Recent and the 2nd Most Recent Monthly Report.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
You have already made a summary field of the Maximum Record ID# and looked it up back down to the child record. Let's name that Record ID# of 1st most Recent Monthly Report.
Now make another Summary field (duplicate that one if you like) and make it subject to the filter that the Record ID# is less than the Record ID# of most Recent Monthly Report, call that the Record ID# of the 2nd most Recent Monthly Report. That is like saying not counting Usain Bolt, who won the last 100 dash at the last Olympics, and of course the answer would be Justin Gaitlin, who "won" if you don't count Usain Bolt being there ahead of him 0.08 seconds ahead.
Then you can summarize up the mileage for respectively the 1st Most Recent and the 2nd Most Recent Monthly Report.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Am I getting the maximum record ID or the maximum mileage?
------------------------------
Ermias Bean
------------------------------
------------------------------
Ermias Bean
------------------------------
- MarkShnier__YouI 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
------------------------------- 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
------------------------------