Trim fewer at a time. First, find the oldest record:
Select min(CallDate) from Calls
Now start from there going a day at a time:
Delete From Calls
Where CallDate < 'x/x/x/'
and then incrementing by one day each time. You might be able to get
away from weeks or months at a time, but it depends on how many
records you have in your Calls table.
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list, including removal,please see http://www.iea-software.com/maillist.html