Results 1 to 3 of 3
  1. #1
    uoghk is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jan 2022
    Posts
    149

    how to set two report detail

    I have 3 tables: invoice, invoice-items, invoice-notes.
    how to set the report to print
    1. invoice print in header section
    2. loop through the invoice-items to print in Detail section
    3. loop through the invoice-notes to print in "another" Detail section
    how to add another Detail section to print the invoice-notes ?
    thanks

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,914
    Look at subreports
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,524
    in report design, set the link field property on the sub reports to link to the master key on the master report.

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

Similar Threads

  1. Sum Text Box Value from Report Detail
    By ryp in forum Reports
    Replies: 1
    Last Post: 09-20-2018, 10:58 AM
  2. Replies: 1
    Last Post: 08-19-2016, 05:10 PM
  3. Hide Detail In A Report
    By Derrick T. Davidson in forum Programming
    Replies: 2
    Last Post: 01-29-2016, 02:02 AM
  4. Report with Two Detail Sections?
    By beribimba in forum Access
    Replies: 2
    Last Post: 08-30-2011, 03:04 PM
  5. report detail duplication
    By archie in forum Reports
    Replies: 5
    Last Post: 09-17-2009, 08:51 PM

Tags for this Thread

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