Help with columns

  • Thread starter Thread starter peggall
  • Start date Start date
P

peggall

I need to create a report where the data is in one file and I need to have
the columns look like this

date/time date/time date/time date/time date/time
value value value value value
value value value value value
value value value value value
value value value value value
value value value value value

The table is laid out like this:
date/time value

I thought that if I made a report with the columns across and then down for
the
date/time and then a subreport with the columns down that it would work, but
it is not.

Any help would be appreciated.
Peggy
 
The table has the following fields/columns:
Account
Date
Time
Collby
Finding
Value


I want the Date/Time and Coll By to print in columns across the page with
the Finding and Values to print underneath each corresponding Date/Time
heading.

I did some more reading and when I bring the query that I am using up in
Pivot Table form, it is what I want but I am having problems getting to the
report.
 
You did not indicate 'Coll By' in a column in the orignal post.
Post greater detail of your desired results and sample data.
 
Specifically this is how I want my report to look:

Date/Time Date/Time Date/Time Date/Time Date/Time
CollBy CollBy CollBy CollBy
CollBy
Finding Value Value Value Value
Value
Finding Value Value Value Value
Value
Finding Value Value Value Value
Value

Finding's and Values will go on down the page.

Like I said, if I do a Pivot Table Query it is exactly what I want but don't
know how to get it to print in a report.
 
If I understand, you might try create a single column subreport that displays
the values. Then create a mulit-column main report based on only unique
Date/Time and CollBy values. Add the subreport into the detail section of the
main report and set the link master/child to the date/time and collby fields.
 
Back
Top