Results 1 to 5 of 5
  1. #1
    cacabanga is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    2

    Horizontal presentation

    Hi !



    My table :
    theme : theme1, theme2, theme3, theme4, theme5
    soustheme : soustheme1, southeme2, soustheme3

    In my BDD :
    theme1 soustheme1
    theme1 soustheme2
    theme2 soustheme2
    ...

    Imagine I want to do a form in which I have :

    theme1 | theme2 | theme3
    soustheme1 | soustheme2 | soustheme3
    soustheme2 | soustheme1 |

    It displays a tabular with all items in the BDD. My real problem is that I do not managed to have a horizontal presentation.

    Is it possible to have this kind of presentation if I know a bound or exactly the number of theme ?

    yannick

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    There are several methods to explore. Common topic. Search forum or Google (crosstab, horizontal, left to right). Start with
    http://forums.aspfree.com/microsoft-...ry-322123.html
    http://allenbrowne.com/func-concat.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    mitchel is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2012
    Posts
    9
    Tried the horizontal display. It didn't give quite the results I was hoping for. Looks better vertically.
    Thanks

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    I am curious, what method did you use in the trial? Allen Browne's code?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    mitchel is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2012
    Posts
    9
    Yes, I used Allen Browne's code.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. PivotChart presentation
    By wharting in forum Forms
    Replies: 5
    Last Post: 08-25-2011, 11:07 PM
  2. Horizontal to Vertival
    By snoopy2003 in forum Queries
    Replies: 1
    Last Post: 03-16-2011, 04:29 PM
  3. Horizontal DB convert
    By williamtak in forum Access
    Replies: 2
    Last Post: 12-09-2010, 08:05 PM
  4. Horizontal Fields
    By labadee in forum Access
    Replies: 1
    Last Post: 06-27-2010, 09:22 PM
  5. Horizontal listbox - ?
    By bane in forum Forms
    Replies: 3
    Last Post: 04-20-2010, 06:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums