Most Recent Record??

Question

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. I need the most recent miles (I know how to get this), however, I want to know the miles reported in the prior month too and the different between the two.

------------------------------
Ermias Bean
------------------------------

MarkShnierYou · Answer

npYou 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community