Display Record Count
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?