This is a quick project with importing csv files, and show the data in table(report) and a chart. The result shall be filtered by different values.
What this Access programm shall do:
Import weekly sales Data from a csv file by a button click, and ad the data to a table.
There is a 2nd csv file ([url removed, login to view]) to filter the table and the chart to show the required data.
This shall work as a deployed standallone version and with source code on my Access 2002 Version.
The Software shall Import data from the csvfiles: Renner-Penner(3-5).csv and new ones each time I want it. The number in the () stands for the week from the data and should be a value in the resulttable for the time(week).
An Product is identified by the Item Id and for each Product the SoldItem Value and the ContributionMarginOne shall be added in a new field in the table with the Week for wich the data is as header:
And this shall be displayed in a table(Report) and a chart. So a chart for each item with SoldItems in dependency of the week, and one for each item with the margin in dependency of the week. The week is included in the imported file as value in ().
Import a 2nd csv file ([url removed, login to view]) on Buttonclick with data from products in a table for basic informations about products. This will be updated once a month, the data is to filter the data shown in the results table.
Filters for the data should be:
1)Only items where the solditems are in week b x% less then in week a, where you could fill a,b and x in textfields
2) Duration until stock is out of stock for this there is an import csv with ItemID;Stock . For the Duration you can divide Stock through Sold items from the last week imported
3) Some Values that are defined in the statik_item database:
4) ContributionMarginOne divided through SoldItems from the table Renner-Penner().csv
The files are cut of I give you full length files after I accepted you as worker.
21 freelancers are bidding on average €157 for this job
[url removed, login to view] I have gone through your project requirements and the csv files. I will complete the project within 3 days only.. Please see the PMB for details Thanks Prashant
Hello, I have 12+ years experience developing MS Access applications and feel confident that I could do this project for you. Please view my portfolio for some examples of my work. Thank you.
Hi, I'm an expert Access programmer and can develop the CSV import functionality for you. Can complete in 2 days. High quality work - satisfaction guaranteed! Thanks for considering my bid. Bests, Larry
Consider it done.... I will help you achieve results above and beyond you expectation with a quick turnaround...Hope to achieve next positive feedback from you!!! Please check you inbox for more info.
I this is a simple project to implement we have a ready solution for the same only minor changes are required to customize it as per your requirement.