Multiple AND single columns in ONE report

[jnrdavo]

Is there a way to have both multiple column (snake) data and single column data on the one report?

I have tried by creating two separate reports and adding in the second one (the one with 3 columns) in to the first one, but no luck...

Any suggestions>

 

[Remou]

This download should help:
Access 2003/2002/2000 Sample: Multiple Column Reports database

http://www.microsoft.com/downloads/...67-F64D-4469-892E-B13E1A1057E9&displaylang=en

For example, the report header or footer can be used for the full width report.

 

[jnrdavo]

Thanks Remou, but not what I am after.

I should have put the key word in caps...

"Is there a way to have both multiple column (snake) data AND single column data on the one report?..."

so I want BOTH multiple columns for some data and SINGLE column for other data (in a subform)...

 

[Remou]

When I tested, I inserted a single column report as a subform into the report header of the sample three column report and it worked. Is this not what you wanted?

 

[jnrdavo]

ah ha! I've been trying the other way around (three column report inserted in to a single column report). I'll give it a shot, thanks!