Search results

I use the following steps to create the merged table: 1. transfer 6 tables from 3 databases (2 tables from each DB). - each DB uses the same naming scheme, so the imported tables are renamed 2. an append query is run on the tables from each DB (one at a time) 3. the resultant table is...

Thank you but I do not know where to enter this information. Is there some way to write a macro that will add a column to a database and fill in the same value into each of the cells in that column? If this can be done, then it should be an easy matter to include that column information in...

I need to merge data from several tables for analysis by a third-party program. The TPP will cause the data to be reordered, amongst other actions. After TPP analysis, the data is brought back into Access for reporting. I need to know which table the data orignated from. Is there some way to...