managing report

[mfuada]

Hi, right now i have a report with this view:

year :1999
price: 20$
item : box a

year : 2000
price : 30$
item : box a

i would like to change the position of those field so my report will have this view:

year :1999 year:2000
price: 20$ price:30$
item: box a item : box a

what should i change? is there any suggestion?
thx!

 

[Dennisk]

first thing to do is convert the underlying query to a pivot table (cross tab query), then specify the column headings in the query.

Finally change the layout of the report to reflect the new record source.

 

[HiTechCoach]

This may help:

Return a concatenated list of sub-record values

Another option would be to use a a sub report set to use columns for the items.

 

[HiTechCoach]

If you would like to use a crosstab query, I have attached an example that is dynamic.