>I have given fields in a table of allowed cost, amount due, claim#,name, id # etc
>I need to report summary of totals by month, totals of claims , amt due, allowed amt.
>
>I figured out how to convert the date format of 19970125 to a field named mo. that has the 01 month in it .
>but having trouble figuring out how to get summary totals only for months and get rid of all the individual
>claim data.
>
>Thanks for reading this.
>
>Joe McNamara macstl@inlink.com
Joe,


Create a report that has a gourp on Month, then put the claim data in the detail band and the totals in the gourp footer band. When you run the report use the summary keyword, as in;

REPORT FOR MyReport SUMMARY TO PRINT

This way when management comes back and says , "Hey can you get us the detail to support these totals?" you just runt he same report without the summary keyword and get them the details.