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
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