2 Replies Latest reply on Aug 26, 2009 10:16 AM by Karnel

    Display Record Count

    Karnel

      Title

      Display Record Count

      Post

      I have a database that will have the status bar hidden when users login.  I would like it to still display the Total records in database.  I know there is a way using the Count () function, but I'm having trouble getting it to work.  I was thinking you cannot have a table count itself so I tried doing a self join and create a calc field in the join table to count the original table's id field, but all it returns is 1.  What am I doing wrong?

        • 1. Re: Display Record Count
          LaRetta_1
            

          You can create a calculation (result is text) and make it unstored in Options with:  Get ( TotalRecordCount)

           

          And you can get a bit fancier with something like:

           

          "Record " & Get ( RecordNumber ) & " of " & Get ( FoundCount ) & Case ( Get ( FoundCount ) = Get ( TotalRecordCount ) ; " Total" ; " Found" )

           

          • 2. Re: Display Record Count
            Karnel
              

            AWESOME!!  That's exactly what I needed.  Guess I was trying to complicate things using a self join table.

             

            Thanks for your help!