Crosstab: Grouping Monthy Entries

[tommaccoy]

I have a table with the following columns

product : Name of Product
Sold at : date
Amount : Amount

I want to generate a crosstab showing the each product (row), the MONTH
(column) and the total amount of each product sold within this month.
Currently Im only able to show this by every entry date but this is not the
grouping I want.

How can i group the single dates into the correct month

Currently I have to enter the Name of the Month 08-01, 08-02 in a separate
column next to the date of sale.

Hope for some help
Tom

 

[Jeff C]

Month:Format([datefield],"yy mm")