Hello,
I am trying to combine the data from 3 tables with identical fields - the 3 tables contain payment/invoicing tracking information for products for 3 different years. Only the table for 2002 will continue to be updated.
After I combine all of the tables (some products will appear each year, so there will be duplicates), I would like to set up a macro that would export certain fields of information to another Access Database. I would also like only the most recent information to export to the new database - meaning that if we paid for a certain software this year and last, then I only want this year's payment information to export to the new database. Each time the payment table is updated, I would like this updated information to be exported to the new database. I do not want to set up a link that would change any information in the payment table, however. Can anyone tell me how to achieve these goals?
I am trying to combine the data from 3 tables with identical fields - the 3 tables contain payment/invoicing tracking information for products for 3 different years. Only the table for 2002 will continue to be updated.
After I combine all of the tables (some products will appear each year, so there will be duplicates), I would like to set up a macro that would export certain fields of information to another Access Database. I would also like only the most recent information to export to the new database - meaning that if we paid for a certain software this year and last, then I only want this year's payment information to export to the new database. Each time the payment table is updated, I would like this updated information to be exported to the new database. I do not want to set up a link that would change any information in the payment table, however. Can anyone tell me how to achieve these goals?
