For a electrical company in Cape Town
So have a excel sheet(csv) with all the out standings /debtors from the accounting system.
I want to do it in MSaccess(2016) instead of EXcel as access more robust
CSV can be imported from excel into a Access table as a linked table.
What I want to do in Access is have extra columns on the database(linked table) to write updated comments or create two new fields which can be worked on to give a status update.
Issue is that if the sheet is updated(from excel which comes from Accounting system) it needs to keep those updated comments relating to that client if money still owing and if the client has paid the line will disappear as client not on outstanding anymore or not on excel sheet anymore
Could this be done and how much?
13 фрілансерів(-и) у середньому готові виконати цю роботу за $41
i am ready and fast to deliver this work and very confidential to my duties Relevant Skills and Experience i have much competence in these. Stay tuned, I'm still working on this proposal.
I can provide a workable solution. Relevant Skills and Experience Excel, Access, VBA, database design and management Fullstack developer Financial Analyst Proposed Milestones $25 USD - Provide workable solution