Results 1 to 7 of 7
  1. #1
    Olgana is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2016
    Posts
    4

    Making two or three columns instead of one

    I created a simple database with visitors. In my report a have just a few posts.

    Date
    Contact person
    Phone number
    Company

    And then a list over the group over visitors.

    If there are many visitors the report vil look a bit like this

    01.02.16
    James McFadden
    123 456 789 00
    Shell



    Phil Ashford
    James Hall
    Jessica Hanson
    Angus McIntyre
    Susan Greyford
    ... and so on.

    If a have a list over 50 people it will fill up the page verically, but is it possible to take advantage of the space horizontally?

    01.02.16
    James McFadden
    123 456 789 00
    Shell

    Phil Ashford Angus McIntyre
    James Hall Susan Greyford
    Jessica Hanson

    I little more like this, with two og three columns with visitors instead of just the one. I can always make three diffrent posts in the form, but can this be done straight in the rapport?

    Sorry for the bad english!

    Edit: The splitting into to colums didn't look nice in this post, but hopefully you get the idea.

    Edit 2: Wow, I see now that I posted it in the wrong place. Should have been postet under "Reports".

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,610
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    Olgana is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2016
    Posts
    4
    For some reason that didn't do any different. I followed the example step by step, but the result is the same; just one single column. I even tried with a new report with just the name of the visitors, no contact person and info, and it still gave just one column. Strange.

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,610
    Can you post a copy of the db
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  5. #5
    Olgana is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2016
    Posts
    4
    I'm at work at a "safe connection", so I can't upload the database apperantly. But this is the screenshot of how I followed the example.

    http://bildr.no/view/TU5mVWd2

    http://bildr.no/view/YlVaZEdW

  6. #6
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,610
    Not sure that the difference would matter but you don't appear to have changed all the settings as illustrated in the example (Under "Column Size", set the Width to 3".)
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  7. #7
    Olgana is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2016
    Posts
    4
    Ah, in the example it says inches, but I am using cm But Google gave me the wrong answer I see now, 3" is 7.62 cm, but it didn't help changing it either.

    Just for fun I created a new database with a simple table with one post and 40 records and made a report based on that. It still wouldn't split in two columns. Maybe there something I need to active in Access?

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

Similar Threads

  1. Replies: 2
    Last Post: 10-26-2015, 06:14 AM
  2. Dynamic Columns - Import new columns?
    By memaxt in forum Import/Export Data
    Replies: 2
    Last Post: 06-24-2014, 06:02 AM
  3. Replies: 2
    Last Post: 05-15-2014, 06:15 AM
  4. Replies: 4
    Last Post: 05-29-2013, 01:29 AM
  5. Replies: 1
    Last Post: 03-08-2013, 12:30 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