Information générale
Catégorie:
Codage, syntaxe et commandes
>>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 .
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement