If you have orphan records, then they will be there until you clean
them up. The 1 and 2 will evenually change over time. If they
don't change for the day, you probably don't need to run a
consolidation.
> Also I cant believe that there aren't call records for canceled accounts
> there has to be a bunch that can be deleted.
> I saw a script you sent someone that deleted from Calls if the
> account was not there.
If the numbers in 2+ aren't changing, then there probably are some
orphan records. I have't to look at your DB to really give you
an answer.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com