Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Report Layout

Status
Not open for further replies.
Nov 6, 2002
89
CH
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top