Grouped columnar report

[BrockLanders]

I accidentally posted this under the Forms forum and was told to put it here.
Anyway, I'm using Access 2000 and wondering if it's possible to have a columnar report that's grouped on a particular field. This way other common fields can be compared across each other, similar to a crosstab query. It's hard to explain, but easier to illustrate:

Company ABC Company XYZ
Yr 1 Sales
Yr 2 Sales
Yr 1 Costs
Yr 2 Costs
etc.


If anyone has an idea how to do this, please point me in the right direction.

Thanks in advance.

 

[lupins46]

It depends what your records look like.
You might be able to use a crosstab if the fields fit the requirements for a crosstab. This would definitely be the easiest approach if it is feasible.

Failing that, you could create a series of (vertical) subreports just showing the values and lay these out side by side but this means that you must know exactly how many companies there are when you design the report.


I think you should post back with a description of your records and some sample values.