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

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.

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.

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.

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

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