report with multiple records

[kedarj]

Hi All,

I have a table with following structure:
Product ID
Pricing Type
Price

There are three types of Pricing types. The records look like this:
Product ID Pricing Type Price
1001 Consumer Price 23.32
1001 Manufacturing Price 18.90
1001 Tax-free Price 20.20
1002 Consumer Price 22.32
1002 Manufacturing Price 17.90
1002 Tax-free Price 19.20

I want the report to look like this:
Product ID Consumer Price Manufacturing Price Tax Free Price
1001 23.32 18.90 20.20
1002 22.32 17.90 19.20

Can anyone help me on this?

cheers
Josh

 

[pbaldy]

Have you tried a crosstab query/report?

 

[EdFred]

On your report go to sorting and grouping, and group on the Product ID Field.

Right click on the detail bar in the report in design view. Select Product ID as the field/expression. In the group properties of the Product ID you will want to group on each value.