Side-by-Side Comparison Report

[mjseim]

I'm bewildered by the fact that I can't seem to find any threads on this...

Nevertheless, I am trying to create a report from my Access Database that will list my records (up to 20) in the header of my report. Then, in the details section you would see all the field names on the far left column. In the rest of the details section you would see the values of each field.

That's the long way of saying... I would like to create a side-by-side comparison report in Access. Is this possible? I would create a simple Pivot Table in Excel but the majority of my values are Alphanumeric, not numeric. Therefore, Pivot Tables aren't that useful.

Thanks.

 

[llkhoutx]

Rethink what you are doing. Take a look at subreports, that's what you need.

 

[mjseim]

Perhaps I wasn't clear enough in my description. Because unless subreports have attributes that I'm unaware of... they don't work like I'm needing.

If it does somehow involve subreports (which I doubt due to the fact that all of the data is pulling from one table), the subreports would need the ability to grow HORIZTONTALLY, not VERTICALLY.

This is an extremely common report easily created in suites such as Crystal Reports. Most any comparitive analysis tool will allow this functionality.

Perhaps this simple example better demonstrates what I'm looking to do. The fields listed to the left will be static. Therefore, the report will never grow vertically. The number of comparison Records, listed at the top, will grow.

         Record 1    Record 2    Record 3    Record 4    Record 5    etc...
Field01
Field02
Field03
Field04
Field05
Field06
Field07
etc...

If it helps, think about any product comparison website you may go to. You select three different cameras and get a side-by-side comparison for them.

Can anyone help me?