Not sure if you care at this point since it sounds like the towel may have been thrown, but in case Rocky hasn't had enough yet...

SELECT INTO only selects into a temporary table. You'd want to create your new table first, with all of the fields you want, then select into, parse through the recordset and for each unique customer ID, write the new values into the new table and update it.

If Rocky's had enough, then say goodbye and take an aspirin or two, heh!