Need Report fields horizontal

[kayabob]

I need to show months of data expanding horizontally, not vertically down the
page. Like the months as headers with data underneath, like Excel - but I
want the data stored in Access. Anyone know if Access Reports can do this?

 

[Lynn Trapp]

What you need is a Crosstab Query. There is a wizard to help step you
through creating it and you can post back here if you have any questions
about it.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html