+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, Access Reports in Technical; Can you help me out here? I have an Access report that has to list several things a user has ...
  1. #1

    garethedmondson's Avatar
    Join Date
    Oct 2008
    Gowerton, Swansea
    Thank Post
    Thanked 326 Times in 194 Posts
    Blog Entries
    Rep Power

    Access Reports

    Can you help me out here?

    I have an Access report that has to list several things a user has purchased. Some users have 3 items whilst some have 1.

    At the moment, it is creating one report per user per item. So a user with more than one item has three reports.

    Would you know how to make it so three items are listed on one report? I'm stumped although I have done it before - just cannot remember.



  2. #2

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Thank Post
    Thanked 470 Times in 307 Posts
    Blog Entries
    Rep Power
    have a play with the grouping and sorting..

    Group it by user, and choose it to be all on one page.

    I cant remember off the top of my head, but on access 2007 its along the bottom of the report in design view

+ Post New Thread

Similar Threads

  1. MS Access Reports strange thing
    By RabbieBurns in forum Office Software
    Replies: 2
    Last Post: 23rd September 2008, 03:30 PM
  2. Formatting auto date in MS Access Reports
    By RabbieBurns in forum Windows
    Replies: 4
    Last Post: 24th June 2008, 03:41 PM
  3. Access wont create reports
    By Teth in forum Windows
    Replies: 7
    Last Post: 14th September 2006, 04:45 PM
  4. Replies: 3
    Last Post: 10th March 2006, 02:54 PM
  5. Printing Access Reports... or not!
    By Frazer in forum Windows
    Replies: 0
    Last Post: 20th October 2005, 12:03 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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