Hello all,
I am a new user on Access, and have run into a jam with a requirement. I am bringing information in from another source and runing reports and queries. One of the requirements is to have a update table and a permanent table. When the information comes into the update table, it needs to be able to look at the permanent table and update any information that has changed or is different. This could be in the form of new data, or it could just be status changes in current data. It does not matter if the information that is the same for the records would have to be overwritten since it would be the same anyway. Does anyone have a good idea of how I might want to go about this. I appreciate any help on the subject, since I have hit a major road block. Thanks!!!
I am a new user on Access, and have run into a jam with a requirement. I am bringing information in from another source and runing reports and queries. One of the requirements is to have a update table and a permanent table. When the information comes into the update table, it needs to be able to look at the permanent table and update any information that has changed or is different. This could be in the form of new data, or it could just be status changes in current data. It does not matter if the information that is the same for the records would have to be overwritten since it would be the same anyway. Does anyone have a good idea of how I might want to go about this. I appreciate any help on the subject, since I have hit a major road block. Thanks!!!
Comment