I want to inner join two access tables to create a second table then append the information from the second table to a history table. Problem is how? The second table has a parameter that will be pulled from a session variable. I'm trying to use DTCrecordsets and for the life of me it will not work. Please help.