Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2010
    Posts
    2

    Multiple tables/one record report

    Hello there, new guy here, sorry for the bad english.

    I'm having a problem with printing out one record from my table. My table is connected to other tables, and I need to print one record from my primary table.

    I want to print out just one record, with everything thats connected to that record in other tables...

    Whats the best way to do it?

    Please see the picture attached.

    Attachment 1256

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    You would typically use a report with subreports, much as you have a form/subforms there. The master/child links would ensure that the subreports only display data related to the record on the main report. You can use this technique to limit the report to a single record:

    BaldyWeb wherecondition
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Join Date
    Jun 2010
    Posts
    2
    Would you be kind enough to do it? Never mind the looks..

    Attachment 1263

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    I'm more than happy to help you do it; I'm not really interested in doing the project for you.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Report based on multiple tables
    By Pimped in forum Reports
    Replies: 1
    Last Post: 12-16-2009, 04:14 AM
  2. Replies: 1
    Last Post: 12-10-2009, 08:41 PM
  3. From with multiple tables
    By Darth_Katarn in forum Access
    Replies: 1
    Last Post: 09-23-2009, 08:17 AM
  4. Multiple lines per record: Report?
    By cjbuechler in forum Queries
    Replies: 7
    Last Post: 07-30-2009, 08:32 AM
  5. Replies: 1
    Last Post: 02-02-2009, 05:52 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