I have a ms access sales order entry database. I Want to have a form that allows a user to select sales by a monthly date range - for example - sales from 01/01/2017 to 01/31/2017. After selecting the data, I want to refresh a MS Excel spreadsheet with the data.
The Spreadsheet chart groups the sales by salesperson, showing a dollar amount and a percentage of total sales (see image attached). I also want to user to be able to save the excel file and send it to others with the data in it.
I can provide a sample database with orders entered, and the form that selects the data by date range. I can also provide a sample excel file that uses a similar chart - I want the data to be on a separate tab instead of how it is now. (see excel file attached)
I need the excel file created, and populated with the access data so it refreshes when a user selects a date range.
After this small task, I have other spreadsheets that need to be created using the same methods.
Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Access. Email sending with MS Plus
14 freelance font une offre moyenne de $142 pour ce travail
I am an excel expert. Read the project specs. Looks like this project is feasible. Just want to understand and make sure some of the requirements ..so kindly open PM to discuss work and budget..I am based in california Plus
Pleasure to help you. I can handle very well access and excel automation. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel and Access. Proposed Milestones $200 USD Plus
Dear i will complete this project with 100% accurancy I will do my best. Please award me this project. Thank You:) Relevant Skills and Experience Recently I was scrap 40,000 australian data. Please check my profile P Plus
I have worked on databases like ACCESS , SQL , ORACLE for 6 years now. I read your post and i can do a professional work. Relevant Skills and Experience I am oracle Certified and Has worked With NADRA Pakistan. Which Plus
Hello, I loved to work on your project because i am expert in data entry and do this job for you and you loved my work :) Relevant Skills and Experience we are top expert in data entry Proposed Milestones $30 USD - d Plus
i have much experience form excel works. I would complete my work with good quality and without the lack of time Relevant Skills and Experience I am well skilled in this job, I had already done many tasks like this P Plus