Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Need Report Fields Horizontal

Discussion in 'Information Technology' started by kayabob, Oct 29, 2005.

  1. kayabob

    kayabob
    Expand Collapse
    Guest

    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?
     
  2. Loading...


  3. OP
    Lynn Trapp

    Lynn Trapp
    Expand Collapse
    Guest

    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



    "kayabob" <kayabob@discussions.microsoft.com> wrote in message
    news:D0E67C29-684B-4863-8CA3-ABDFD18D34A1@microsoft.com...
    >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?
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page