Complex Grouping for Report

[ss6857]

Hello and thank you in advance.

I am attempting to create a pricing report. I have different products and different prices for these products depending on the level. Example: Level one is orders under $500, Level 2 is between $500 and $1000, and Level 3 is over $1000.

I would like the report to look like this:

..............L1...L2...L3
Product 1 $50 $40 $30
Product 2 $45 $40 $35
Product 3 $70 $50 $30
Product 4 $45 $35 $25
Product 5 $60 $55 $50

Whenever I group it (either on level or product), the product appear 3 times. Like:

Level one
..Product 1 price
..Product 2 price etc
Level two
..Product 1 price
..Product 2 price etc
Level three
..Product 1 price
..Product 2 price etc

Or:

Product 1 Level one price
Product 1 Level two price
Product 1 Level three price


etc

Any suggestions? Sorry if this is so complex.. I thought it would be easier if I had visual examples...

Side question: can you use code to create reports? is it advised?

[NTC]

it is appearing the two ways you show - because that is how the database records data - in stacked rows.

the left-to-right display is not how data is actually recorded; thus you will want to look into the crosstab query/report feature which transforms the display. it isn't the most intuitive feature and will help if you have an access text book.

[ss6857]

I have played around with the crosstab, however, there is more information that needs to be in the report and it only allows a certain number of criteria (3 row headings, and one column heading). And because I created that query from the table I need the rest of the information from, it won't let me put that other information on there when I go into the report wizard.