Results 1 to 2 of 2
  1. #1
    Mclaren is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Feb 2010
    Location
    Johannesburg
    Posts
    164

    additional detail records to be inserted

    I have a report that prints out as per the number of records into the detail section. however, i need to ensure that even if there fwere than 14 records, that the number of line items totals to 14. in other words if 5 there are 5 records, there must 5 lines in the detail section with the relevent information and 9 empty lines.



    Then if there are more than 14 records, a 2nd page must print out but in exactly the same way as the first ie: if there is 16 records, the first page must have 14 in the detail section, te 2nd page must have 2 lines with the relevant records and 12 empty lines.

    Is this possible ? if so, how ?

  2. #2
    Mclaren is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Feb 2010
    Location
    Johannesburg
    Posts
    164
    Hi, just bumping this thread

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

Similar Threads

  1. Replies: 4
    Last Post: 02-11-2011, 10:25 AM
  2. Adding an additional WHERE clause
    By Pells in forum Queries
    Replies: 7
    Last Post: 10-28-2010, 12:44 PM
  3. Replies: 7
    Last Post: 04-27-2010, 10:29 AM
  4. Replies: 0
    Last Post: 03-01-2010, 07:42 PM
  5. Additional params for ANY query
    By dnagir in forum Access
    Replies: 0
    Last Post: 01-21-2009, 10: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