+ 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
    Location
    Gowerton, Swansea
    Posts
    2,309
    Thank Post
    973
    Thanked 326 Times in 194 Posts
    Blog Entries
    11
    Rep Power
    170

    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.

    Cheers

    Gareth

  2. #2

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,532
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200
    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



SHARE:
+ 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
  •