Report Layout Question: Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My apologies if this has been asked before, but I'm not really certain how to
phrase (or search for) the question.

I'm trying to create a report and have the data flow across the page instead
of down the page. For example:

Instead of this:

Sample No. Sample Date
Value 1
Value 2
Value 3

I'd like to get this:

Value 1 Value 2 Value 3
Sample No.
Sample Date

I tried a pivot table, but I don't want to calculate anything.

Any help is appreciated!
 
Seems like a crosstab query would do it. How is the data stored?
Like this ---
Sample No. Sample Date Sample Value
abc 1/1/07 1 5
abc 1/1/07 2 4
abc 1/1/07 3 2
def 1/1/07 1 4
def 1/1/07 2 3

TRANSFORM First(RobinK.Value) AS FirstOfValue
SELECT RobinK.[Sample No], RobinK.[Sample Date]
FROM RobinK
GROUP BY RobinK.[Sample No], RobinK.[Sample Date]
PIVOT RobinK.Sample;
 
Back
Top