Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is it possible to display the count of total no. of rows in a table on the title?
I cannot use count(field1) for e.g. to display the count as it will just give the count of field1. I am looking for the count for the actual rows created.
Count( field1 ) will indeed show the total count of records in the table - well, except for the records where field1 is NULL.
So if you use an expression
=Count( field1 ) + NullCount( field1 )
then you will have the number of records.
/HIC