Report With Multiple Columns

  • Thread starter Thread starter Deron Thompson
  • Start date Start date
D

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!
 
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
 
Back
Top