Summary or toal

[vbfj]

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.

[mr_vodka]

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.

[vbfj]

can u please xplain how to "Self Join"

Thanks

[mr_vodka]

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

[comment]

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

[pmconaway]

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?

[mr_vodka]

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. ;)

[vbfj]

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)