I am trying to convert a table from one format to another. The new format has a key in it, made of 3 columns. The old table has duplicates of the key columns, but often with distinct data. I have written a VBA function to convert one of the columns,taking into account keys and data already passed to the new table. Alas, for every call to the query nothing has been passed, because actual passage of data takes place only after all the input has been processed. There must be a way to have rows passed at once so that succeeding rows can be compared with them. I think there may be a special SQL statement to suspend the caution which is this time being a nuisance, or perhaps there is some adverb for the INSERT statement. Does nayone know what the technique is?