General information
Category:
Coding, syntax & commands
>>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
I will try this as a alternative method to the one I used from Jim Booth it seems like a fast way to get numbers .
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only