I am receiving data from an external source on a weekly basis, does anybody know how I can append the records so that current records are modified so show the new status.
Errmm, seriously, there is an example just like this in the access manual and any reference on access will give you a very similar example.
What source is your data coming in as? From Excel or some other source?
I'm sure you'll get a more detailed answer soon, but basically you need to convert the manual process you do each week into a script which does it automatically.
Good luck.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.