How to display next records in a side-by-side format??

[sjh]

I have a table with the office equipment inventory. I have to create a report for the asset valuation. The report format should look like the following:

Office A Office B Office C Total Percent
Purchase Price (PP)
Depreciation
Current Price (PP – Dep)
Avg. Condition (CP / PP)


What is the best way to create this report? I don’t know how to manipulate the Access Report to create the look I want. For example, I created a columnar report which looks like this.
Office A
Purchase Price (PP)
Depreciation
Current Price (PP – Dep)
Avg. Condition (CP / PP)

But these labels gets repeated for Office B and C, instead of listing all the office data side-by-side like the first example. And the total should also be displayed on the side. There must be an easier way to do this. Please share your wisdom. Thank you. - sjh

Bytheway, the table has the following columns:
ItemNo
OfficeLocation
PurchasePrice
Depreciation

 

[mpastore]

Have you looked into doing a cross-tab report?

 

[sjh]

I tried using Cross Tab Report. I stored Purchase Price, Depreciation, Current Price, and Avg.Condition in a table called "Labels". Then I modified my data table so that the values of each labels was referenced by LabelsID.

Is this the correct way to create the cross tab report? This isn't very intuitive to me, so I was wondering if there was a easier way - I want to know whether displaying next set of data in a side-by-side format is possible.

Thanks!

 

[CosmoKramer]

The report should be based on a Crosstab query. Check out Access help for the Crosstab Query Wizard and give that a shot. Just follow the directions for assigning fields to the rows & columns....

Let me know if this helps...