running totals for states for mileage records

[Zcast]

Hey everyone, could use your help with this problem. I have a mileage db where i have to keep a running total of miles ran through each state, so I can print out a quarterly report for my boss. I have an "newbie" idea of how to go about this, but it doesn't work. (Go figure ,huh?) Not sure where to go from here. Your help would be greatly appreciated. I have attached my example file for your review.

mileagedb.zip

[comment]

Use a summary field (Total of Miles), placed in a sub-summary (by State) part of the layout. Sort the records by State when producing the report.

[Zcast]

Thanks comment for your reply, but being a newbie, i"m still confused. How many fields or what script(s) do I need to set miles for the correct state? I get the total miles should be a summary field, but based on what? It doesn't give me a choice to choose from, and that I need to place that field in a summary part of the layout (that I get). I still cant get the correct totals by state...probably not cripted correctly.

[Zcast]

well, after splashing my face with cold water, and looking at what you said, it made sense to me now, and seems to look correct in the report I created by doing what you said. Thanks for all your help comment..truly appreciated.

[comment]

See if this helps.

Note that in a real implementation, you'd likely use a separate layout for the report. along with a script to produce it (go to report layout, find the right records, sort, print).

mileagedb.fp7.zip

[Zcast]

thanks again for your help comment, your example really clarified alot for me.