I want to generate a report that is sorted by month and which lists the
sales of two kinds of widgets each month.  I have created a sub-summary
field which sorts great by month and it will give me the count of all
widgets sold but I'm not sure how to summarize for each widget in the
database.  The widget name is stored in a field called "product".  I've
tried the self-join approach but that's not working.  Thanks for any
suggestions.

Adam

I figured this out.  I needed to use multiple summary parts ...

Adam

"Adam G. Garson" <aggarson@hotmail.com> wrote in message
news:bpednUCiXPpUib7dXTWc-g@speakeasy.net...
> I want to generate a report that is sorted by month and which lists the
> sales of two kinds of widgets each month.  I have created a sub-summary
> field which sorts great by month and it will give me the count of all
> widgets sold but I'm not sure how to summarize for each widget in the
> database.  The widget name is stored in a field called "product".  I've
> tried the self-join approach but that's not working.  Thanks for any
> suggestions.
>
> Adam
>
>