Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Campo, CA, USA
    Thanked 0 Times in 0 Posts
    In Access 2007, I created a report list that counts the number of records. I made the list two columns. However, the count total is generated on a new page, not below the last record at the end of the second column. There is space for it (The second column ends about half-way down the page). How do I get the record count total to display under the last record listed instead of a new page? Thanks in advance!

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 65 Times in 64 Posts
    One of the easiest ways is to put the record count in the report footer, and make sure to provide enough room at the bottom for both the report footer and the page footer if it is being used. At some point it is bound to run out of room if the record count exceeds a certain amount, but as long as you don't have two full columns it should work.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts