Summary Data

[sislman]

Hi,

I have a table with in excess of 50k lines of data. I would like to sumarise this data in a report based upon a query.

I have written the query which cuts the data down to about 4k lines and I want to summarise the data under the following headings:

"Date Sold", "Total Premium" , "Earned Premium"

How do I do this without the report being about 2000 pages.

Also, how would I go about reporting by Month of Sale. Currently my dates are in DD/MM/YYYY format.

Any help would be appreciated.

Regards

 

[Brianwarnock]

Assuming each record contains a Datefld and Total Premium, Earned Premium then group by date and sum on the other 2 fields, if this is not the case more info required.

Create a Field fldMonth: Month(Datefld) and Group By this field.

Brian