I have a listing of invoices for the day with summarys for the day at bottom of report. How can i include summarys of fields for all records for the current month. example: i have summary of sales for the day. I would like to include summary for Sales for the month todate.

If you create a calc field with the following:

Date ( Month (SalesDate); 1; Year (SalesDate) ), and have a self join keyed on this calc, you should be able to count or total up those records with a summary field.

can u please xplain how to "Self Join"

Thanks

copy the table occurrence and then join both of them on the calc field

Is the relationship required at all, if this is going to be a report?

Why not add another summary section at the bottom of the report and have it be a sub-summary by month section. And then sort by month as part of the report script?

Oops missed that it was for a report. For some reason I thought the records were in a portal. I really do need to be more careful in reading the posts and in watching what forum it is posted to. ;)

The report needs to firstly display the transactions in detail for the day only then the totals only for the month (without displaying all the months transactions)