Report Formatting - Summarizing Data

[Guest]

Hi all,

I can create a form that summarizes by data as shown:

Title 1: XXXXX
Contact: John

Stage Name Date Comment
1 Fred 1/1/05 N/A
2 Peter 2/1/05 Completed

The above is then repeated for Title 2, Title 3 etc.... going down the page
(in fact a new page for each Title)

Is there any way to format the report so that it looks more like:

Stage 1 Stage 2 Stage
3.....................
Title 1 Name Fred Peter
Date 1/1/05 2/1/05

Title 2 Name John Bob
Date 4/4/05 3/6/05

Basically I want to be able to summarize the individual titles as shown above.

Thanks

 

[Duane Hookom]

There are sample crosstab reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4 and an article on
multiple column reports with labels on the left at
http://support.microsoft.com/default.aspx?scid=kb;en-us;210044&Product=acc.