Results 1 to 5 of 5
  1. #1
    Abdulaym is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jul 2023
    Posts
    33

    Report

    Hi, I have 2 questions?


    1. printing invoice through report and each report for every customer should be on a separate page and show the current customer records for printing?

    2. How do I print records from subform. Because I want to continue to use the CustomerID for each customer. So how do I print a specific records in the subform. For example yesterday customer older 1. Rice 2. Beans and also come back today and order 3. Milk 4. Rice. So how do I print today and yesterday order from subform. Your response will highly help Thanks

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    1. Use report Grouping feature to group by CustomerID and set group section ForceNewPage property to AfterSection.

    2. Not really sure what you are asking for. Print report not form. Apply appropriate filter criteria to report.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Abdulaym is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jul 2023
    Posts
    33
    Wow Okay, I really appreciate. I now understand question 1. But I still have a question based on question 1 is there any way I can search for record based on CustomerID and Dates in report. Thanks for your usual assistance

  4. #4
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,566
    It does not help that you are posting multiple questions about the same topic.
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Can do some ribbon and right click search operations with report in ReportView.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 6
    Last Post: 05-25-2018, 09:53 AM
  2. Replies: 16
    Last Post: 03-13-2018, 05:24 PM
  3. Replies: 9
    Last Post: 07-03-2017, 11:24 PM
  4. Replies: 4
    Last Post: 12-09-2015, 09:02 AM
  5. Replies: 3
    Last Post: 10-19-2015, 11:05 PM

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