Results 1 to 3 of 3
  1. #1
    jvander is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2017
    Location
    Ontario Canada
    Posts
    1

    Question multiple sets of information on same report

    hi there,

    I don't necessarily know how to explain what I am trying to do but maybe someone out there has the correct terminology and answer.
    I'm working on a database with some basic contact information. We are currently manually updating about 10 different versions of contact lists in MS Word for our organization. This is obviously a huge time waster in duplicate entry and such, not to mention the amount of cross checking and potential missing or inaccurate information is quite high. The database is setup and I'm now working on the reports.

    the data I'm looking to report on now is stored in two tables currently
    table 1
    building name, address, phone, fax

    table 2


    employee name, building name (links back to table 1), extension, home phone, cell phone, job title

    the report I want to create would include the building name, phone, fax as the heading
    then the detail would include the employee name, ext and job title.

    Kind of like this
    Building Name
    Phone # ,,,,,,,,,,,,, Fax #,,,,,,,,,,,,
    employee name ext jobtitle
    employeename 2 ext 456 my job title
    empl name 3

    the problem is there is so much wasted space on the report that I would like to report multiple locations across the page such that there would be two or more building names across the page

    ie Building 1 Building 2 Building 3

    see attached word doc for an estimation of what I am looking for.

    is there a way to do this in Access. if so how.


    Any assistance than can be provided is greatly appreciated.
    Attached Files Attached Files

  2. #2
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349

    To start with, please post a copy of your database (confidential information sanitized) - we will be able to help you alot better. Compress the database into a WinZIP (.zip) file before uploading.

  3. #3
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Put the data into a subreport and then use columns as explained here https://www.techonthenet.com/access/...eport_2007.php

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

Similar Threads

  1. Multiple sets of date
    By WhiskyLima in forum Reports
    Replies: 6
    Last Post: 06-24-2014, 03:30 AM
  2. Replies: 1
    Last Post: 10-21-2013, 09:42 AM
  3. Information from multiple query's on a report
    By pleshrl in forum Reports
    Replies: 3
    Last Post: 04-21-2013, 04:53 PM
  4. Crosstab => Multiple Sets of Values
    By Minimalist in forum Queries
    Replies: 1
    Last Post: 01-07-2013, 01:17 PM
  5. Multiple Sets of the Same Data on 1 Report
    By rmikulas in forum Reports
    Replies: 1
    Last Post: 08-07-2012, 10:09 AM

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