>Thanks (all),
>but yes, 90% of the fields are matching. I dont want to have to delete the extra fields.
>I need to merge 6 "orders" tables from 6 working systems each with subtle differences.
>
>Naomi had some code.. but not sure I want to have to use it.
>
>still a bit perplexed.

Download Frank Dietrich's CEE editor extensions - there's a few intellisense macros, among them FIELDLIST macro which will insert the list of fields for the currently selected table (or alias of your choice). Do that for each table, then just erase the fields you don't need.