AnsweredAssumed Answered

Omitting Archived Records From Total Count

Question asked by Frinholp on Dec 20, 2010
Latest reply on Dec 20, 2010 by Frinholp


Omitting Archived Records From Total Count


Hi all

In my solution I send all records to archive rather than delete. This is acheived by setting a record's status using an 'Archived' field who's value is a boolean.

I currently show the record number, total of found set, and records in total for all my tables using merge fields on my layouts. I use three auto-calculated fields in each table which calculate the aforementioned values.

Get ( RecordNumber )   

Get ( FoundCount )

Get ( TotalRecordCount )

How would I go about subtracting the number of archived records from the total?

Thanks in advance