Access Report Layout

[StefanScheidegger]

Dear colleagues,

I would like to establish a report with a specific layout.

My current query is as follows:

[Date] [Product] [Price](=DSUM function)
01/01/03 ProductA 100
01/01/03 ProductB 400
01/01/03 ProductC 200
01/02/03 ProductA 800
01/02/03 ProductB 600
01/02/03 ProductC 400
etc.


I would like to show the following layout in my report:

ProductA ProductB ProductC
01/01/03 100 400 200
01/02/03 800 600 400
etc.


How can I achieve that? For your information, it was not possible to create a crosstab query or a pivot-table based on my source query (error notification 3122).

Thanks very much for your continuing support.
Kind regards,
Stefan

 

[67peshawar294]

StefanScheidegger,
Create a new crosstab query using the date, product and price. With your present crosstab you are creating a crosstab with the dsum as a selection and your result is trying to sum the dsum...
jp