Results 1 to 3 of 3
  1. #1
    Joakim N is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Oct 2016
    Posts
    79

    Formula for Total Records in a Form

    I have written following formula in a Textbox:

    =[CurrentRecord] & " of " & [Count]

    The result is when my last record is selected:

    1280 of 106

    I know I have 1280 records in my recordset. But why does my formula says it's only 106 of total records?

    Regards
    \Joakim

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,515
    that [COUNT] is a field ,not sure what yr counting, not a formula.
    use:
    Count([field])

  3. #3
    Joakim N is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Oct 2016
    Posts
    79
    Thanks!

    Joakim

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

Similar Threads

  1. Replies: 4
    Last Post: 07-16-2016, 10:52 AM
  2. Replies: 4
    Last Post: 07-14-2015, 06:49 PM
  3. Replies: 1
    Last Post: 01-24-2013, 05:50 PM
  4. Replies: 3
    Last Post: 08-22-2012, 05:24 PM
  5. Total based on Formula based on field value
    By cjbuechler in forum Reports
    Replies: 15
    Last Post: 07-10-2009, 09:56 AM

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