+ Reply to Thread
Results 1 to 2 of 2

Acess Report the shows data across then down

  1. #1
    Forum Contributor
    Join Date
    04-21-2010
    Location
    Canada
    MS-Off Ver
    Office 2013
    Posts
    120

    Acess Report the shows data across then down

    Kind of hard to define this in a title. The short of it is I need to display data from a query with the records going across 3 columns before starting the next row. The data is seperated by a grouping system. so for example if the query has the data:
    group records
    ---------+-----------------
    groupA | rec1
    groupA | rec2
    groupA | rec3
    groupA | rec4
    groupA | rec5
    groupB | rec9
    groupB | rec10
    groupB | rec11

    I would like the report to show the data like this:

    groupA
    |rec1 |rec2 |rec3
    |rec4 |rec5 |
    ------------------------------------
    groupB
    |rec9 |rec10 |rec11
    ------------------------------------

    I have done this in a form by using a mod trick, but hoping not to have to code that again.

  2. #2
    Forum Contributor
    Join Date
    04-21-2010
    Location
    Canada
    MS-Off Ver
    Office 2013
    Posts
    120

    Re: Acess Report the shows data across then down

    Must retract this... Got it to work with a subreport, and forgot that the column settings has the across then down.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Stock Pivot Report - Macro shows error
    By Biancodi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2015, 09:24 PM
  2. Making a report that shows only values below a certain percentage
    By pbatt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-13-2014, 02:05 AM
  3. Replies: 6
    Last Post: 09-28-2012, 06:22 AM
  4. Replies: 9
    Last Post: 05-17-2012, 09:36 AM
  5. disable acess to external data
    By Cheryl R. in forum Excel General
    Replies: 7
    Last Post: 07-19-2005, 12:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1