Results 1 to 2 of 2
  1. #1
    jasper0092005 is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2019
    Posts
    1

    Problem with Report wil preparing quotation


    Hi, I made a report for printing quotations in access. but unfortunately if my terms and conditions have lengthier lines then the reference footer will be coming as new page even if the previous is only half page. i have attach the copies. please guide me to fix this issue. i wanted the total and terms and conditions to continue on the same page from the below.
    Attached Thumbnails Attached Thumbnails Access report format.JPG   Error-1.JPG   Error-2.JPG  

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    7,379
    No reply yet so I'll jump in. IMHO there are too many section properties involved to know exactly why this is without guessing and they often have to work in harmony. Did you examine such things as "keep with next", "group together on one page" (or not), etc.? You turn on Sorting and Grouping by right clicking on report and choosing it from the menu. You may have to upload a zipped copy of your db at some point if you don't find or receive an answer to what you need. You can always mask sensitive data.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

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

Similar Threads

  1. Quotation DB with EU and Cust
    By Sunny8760 in forum Database Design
    Replies: 2
    Last Post: 03-19-2018, 07:47 AM
  2. Quotation Chaos
    By plackowski in forum Modules
    Replies: 19
    Last Post: 02-28-2017, 01:31 PM
  3. Preparing report/chart
    By intifad in forum Reports
    Replies: 1
    Last Post: 10-06-2016, 05:27 AM
  4. InStr() and quotation marks
    By Puebles in forum Programming
    Replies: 3
    Last Post: 11-22-2013, 07:36 AM
  5. Ways of preparing data for graphs
    By ajetrumpet in forum Queries
    Replies: 0
    Last Post: 09-11-2010, 10:26 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 - Senior Forums