transpose? vertical to Horizontal

[GaryPanic]

Hi guys

I have a report
Transaction by month (by currency)
and it all fine

it gives me
Accname
Amount by month - formated to mm so i get 1 (jan) 2 (Feb) etc
by currency
( based on date range ) x to x -
all fine
but i need it to go left to right currenctly it lists them top to bottom
jan at the top then underneath feb...
ixs there a "simple" way of putting these on the report left to right

jan - feb - mar (01 - 02 - 03 )
rather than
01
02
03

hope this makes sense

G

 

[arnelgp]

your report comes from crosstab query, examine the query and create new query swapping Column heading with Row heading, vice versa.