Results 1 to 2 of 2
  1. 01-26-2012, 03:02 PM #1
    jamal numan
    jamal numan is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2011
    Location
    Ramallah, West Bank
    Posts
    113

    Question How to drive the table shown in the screenshot from a given table?

    How to drive the table shown in the screenshot from a given table?
    Please, have a look on the screenshot in which you find the given data and the required table. Is there a way in access to obtain the required table (shown in the screenshot) AUTOMATICALLY?
    Thank you in advance,

    Regards

    Jamal
    Reply With Quote Reply With Quote
  2. 01-26-2012, 05:25 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,900
    You want records to display horizontally (left to right, across)? This is seldom easy to accomplish, especially with tiered column headers. Common topic, search forum and Google. Here is one
    https://www.accessforums.net/forms/d...lly-20989.html

    Can get close to the tiered effect with grouping on a report but the detail data will still be vertical.
    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.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Imported data in table not shown in Forms
    By Zildjyn in forum Import/Export Data
    Replies: 9
    Last Post: 12-30-2011, 01:34 PM
  2. Link same table to two table.Dataentry in main form & sub-subform from same table
    By ozaman in forum Forms
    Replies: 2
    Last Post: 08-01-2011, 11:35 PM
  3. Date not Sorting Correctly (screenshot attached)
    By KrenzyRyan in forum Queries
    Replies: 5
    Last Post: 06-27-2011, 01:44 PM
  4. Simple calculations to be shown in reports
    By Newaccessuser in forum Access
    Replies: 8
    Last Post: 03-03-2011, 06:58 AM
  5. How to make query based on external access DB's table and the table in linked table?
    By aquaraider in forum Queries
    Replies: 2
    Last Post: 10-27-2009, 07: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
  •  

Forum Rules

Other Forums: Microsoft Office Forums