Count only our "live" contacts

[Richie2837]

Hi,

Our contacts database has the regular record navigation buttons plus the total count of records on the database on the bottom of the main form. This total is made up of all our contacts. However, as we "de-activate" contacts on a regular basis for whatever reason (moved away, deceased etc.) we don't really want to have these counted in the record total. Is there a way of keeping the total number of records displayed at the bottom of the form alongside the record navigation buttons, but filter out all the non-live records from the total?

 

[Oldsoftboss]

How do you "activate / deactivate" your clients. If you use a yes/no checkbox (my suggestion) then create a query and simply put Yes in the criteria of the checkbox field. This will return all active clients. Then sum the records in the query.

HTH

Dave

 

[Richie2837]

Hi Dave,

I use a date field to de-activate, this indicates the date the contact was deactivated from the list (therefore blank fields are still "live"). If I create a query to sum the records, how do I get that number to display on the total number of records on the form?