I need some one to create some advanced queries for MS Access 2007 - 2010.
I need a query that gets records from two or more link tables that share a relationship. The query gets the records and places the record in a new table, I will call the new table local table for simplicity sake.
Than the query runs everyday at a certain time (designated) gets new records from the link tables and place them in the local table.
Here is where it gets important. When the query runs daily, it updates any record that has been changed in the link tables, so if a person address changes, the address is updated in the local table. If there are no new records or updated records in the link table, nothing is brought over. If there are new records, they are brought over.
Finally I need all the data queried from the local table exported as a CSV file to a specific directory or to a server via FTP.
All this needs to happen sequentially, and automated using Macros.
I need this clean and easy to understand.
Lets get to work.
I can demonstrate an identical project which records audit trail for every field change; I am providing you links to verify my experience and credibility on online freelancing, review PM!
$250 USD en 5 días
5,0 (17 comentarios)
4,7
4,7
28 freelancers están ofertando un promedio de $147 USD por este trabajo
HI,
I m the best MS Access expert.
I know exactly how to do what u want using VBA and I d let u set the time of synchronization.
Plz check my profile.
Regards,
Hussien Sharaf
Hello
I can do this for you. I have expertise in MS Access and has developed number of applications in this platform.
Please see my reviews as well.
Regards
Faisal