aligning rows

[Guest]

I have a table with 3 columnsas follows:
Type Store Qty
Dist 604A 2000
Copy 604A 100
Dist 725B 3000
Copy 725B 200

In my report I get the following:
Store Dist Copy
604A 2000
604A 100
725B 3000
725B 200

I would like the report to show the copy quantity on a single line as
followes:
Store Dist Copy
604A 2000 100
725B 3000 200
How do I make this happen?

 

[Duane Hookom]

Check Help on creating a crosstab query.