>Unless there are several thousand records that need updating all this may >turn out to be a waste of time. unfortunately there are in excess of 500k records in this particular table. and there are three other tables that also need the same treatment. joy. kx