Afternoon All,
Firstly I am no expert with excel/access, but I am really hoping someone might help or suggest a solution.
The company I work for have an access database, from this database I have linked an excel spreadsheet to pull over customer information and continuosly update (as customers come and go regularly in our buisness).
I then would like to have a table next to the linked/imported table to act as a knowledged sharing base for the customers.
Let me try to illustrate this if Im being unclear:
Linked Table
Customer Site 12/02/2016 13/02/2016 14/02/2016
MR A Canary Wharf Call
MR B Tolley Street Do not call
MR C Great West Call
So above the fields Customer and Site are pulled from my access database, however the date columns are unbound to this and we use to share the informtion.
Customer Site 12/02/2016 13/02/2016 14/02/2016
MR B Tolley Street Call
MR C Great West Do not call
Call
So above is an instace where MR A has been removed from the database and hence forth removed from the table by automatic update, however the call or do not call data has not be erased, so now someone could call MR B as instructed, however if the data was correct the instrutcions for MR B was NOT to call them.
I hope this makes sense... So my question is this. How do I relate the DATEs to this automatic update?
Regards Kye
Bookmarks