What is a quick query I can run to find out the total numebr of active constituents in our database?
Try this:
use impresario
select count(*) from t_customer where inactive = (select id from tr_cust_inactive where description = 'active')
hope it helps.
Jeff
If you would like to use List Manager you can simply check for Customer ID > 0.
Jared
Great- thanks!