Results 1 to 5 of 5
  1. #1
    Robert2150 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    102

    Navigation Bar Not Showing Correct Total Of Records

    I have a database and the primary table has 168 records posted to it. However, the Navigation Bar at the bottom of my main form shows a total of only 154 records. I can access all 168 records through my form for editing purposes.

    Any suggestions? Thank You.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    How do you determine there are 168 records - by autonumber ID? Are there possibly gaps in the autonumber sequence?
    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
    Robert2150 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    102
    You are RIGHT, there were gaps in my number sequence, I have now corrected them. THANK YOU, THANK YOU.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    How did you do that? Autonumber sequence and gaps should be irrelevant. Users should not even be aware of autonumber. This field should not have any meaning to users. It should just be a means to relate records.
    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.

  5. #5
    Robert2150 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    102
    It's not an Auttonumber field.

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

Similar Threads

  1. Replies: 1
    Last Post: 05-23-2014, 03:38 PM
  2. Replies: 10
    Last Post: 06-03-2013, 10:24 AM
  3. Replies: 3
    Last Post: 09-06-2012, 03:35 PM
  4. Combo Box not showing the correct Field
    By Atlascycle in forum Reports
    Replies: 61
    Last Post: 03-12-2012, 10:51 AM
  5. not correct running total in group
    By cmk in forum Reports
    Replies: 1
    Last Post: 12-06-2006, 05:56 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