Hi Folks,

I am a FM Rookie and am trying to learn fast.. I am trying to track 18 daily truck routes. I have a field for 'miles' and a summary.. however the summary totals everything from day one. I need to track a "Daily, Weekly and Monthly" in a number of fields..ie; miles, stops, etc; But I am not sure of the proper calculation for each.. PLease help a self-learner :

You need these fields (names are just examples):

Route_Date

Route_Week

Route_Month

The date field is where you manually enter the route date (or auto enter the current date). Week and month would be calculated or auto-entered number fields based on the date. See the Date functions.

Your summary layout needs a summary part for each: day, week, and month. The summary field you already have would be placed on each part along with the Route_Date, Route_Week, or Route_Month field. You may want to make a month name field as well to make it easier to read.

Now you can sort by any or all of those fields and then preview or print to see the magic.