Report With Multiple Columns

[Deron Thompson]

I'm trying to create a report that will display multiple
records (from an underlying query) in columns across a
page. For example:

Phase 1 Phase 2 Phase 3
Total Face
Total Retained
Total Ceded
Etc.

The way my report is currently set up, I get the results
for Phase 1 in the first colum, then a new page with Phase
2 results, then a new page with Phase 3 results, and so
on. I'd like to have all records displayed in columns
across one page only. The left-most column would act as
labels for the data and appear only once.
Any suggestions??!! Thanks!

 

[martin]

Depending on the layout of your data you will either need
to do totals(the sum sign looks like a Z) on a select
query (watch what you group on) or base your report on a
crosstab query. Check this website for help on crosstab
queries. http://www.mvps.org/access/

Martin