>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
You can use a query to retrieve the information that you want:
SELECT CMONTH(date) AS month, SUM(amount_due) as Total_due, AVG(amount_due) AS avg_due
FROM table
GROUP BY 1
INTO CURSOR results
-Mike