hi cetin
thanks for this comprehensive reply. i'm going to use your first code example to copy the data into a new table overnight and then let the analysis progs work 24hrs behind the live data.
thanks for your time and effort...