I have two tables of customer information in Access which contain data that I
would like to merge into 1 new table labeled (2009 master mailer). The parent
table (2008) has historical data and includes some information similar to
table(2009), like customers information as well as new customer information.
the only common columns on the two lists are,
basic customer information such as name, address, city, state, postal,
homephone. However table(2009) includes two other columns of information,
"notes" & "project" that I must be able to keep. Please advise the best way
to
approach this situation.