... indexes, creating relationships, creating a third database to hold the summaries, and writing a processing loop. So I came up with this [ Note: ANI is a phone number] =================================================================== cSQL = "SELECT TrunkANI.ANI, Sum(TrunkANI.Calls) AS Call, ...