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" )
AWESOME!! That's exactly what I needed. Guess I was trying to complicate things using a self join table.
Thanks for your help!