Create database query
€250-750 EUR
Paid on delivery
I do a bit of sports trading as a hobby, mainly on the horse racing markets. I maintain a database which I update daily that currently contains 400k+ records. Each morning I download a list of horses due to race that day and manually check them against the database. This is quite time-consuming.
What I require is some mechanism where the daily list of runners is queried against the database and a report generated as a separate file showing the headings of the database file. There can be multiple returns for a horse or none if the horse hasn't run previously.
Ideally, if not too complicated, it would be nice to have the database headings as selectable items in the query mechanism so that headings may be included or omitted as required. If it's not practical to include all headings I can reduce them to those that I feel are necessary.
I am attaching a sample file with two tabs showing samples the daily runner list and the database.
Project ID: #25754039
About the project
47 freelancers are bidding on average €474 for this job
Hello, I can develop a database oriented system for your horse race needs. Let me know when we can discuss. Thanks
Hi i can work for Create database query i am expert at , SQL , Software Architecture , MySQL , Database Programming , Excel VBA So send me Private message at PMB so we can discuss more about it Thanks
Hello. I can do your project. About me: — 9+ year of experience. — Any tasks — Improve your ideas
Dear sir I can create a button in excel which will get you result from using this mechanism. I have been in this industry for 1 year and such jobs are my daily practice. I can assure you that if you work with me once, More
Hello! I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko? More
--20 Years Database Expert with Excel ----- I am very much interested to update your Excel system with full automated system to reduce manual work --we need discuss to start --thanks
With my 12+ years of Software Development experience like to work on your project,Please see my reviews to consider me as your development member. ASP.Net, C#, VB.Net, MVC, WPF,Android Application,iOS Application, Vis More
Hi, sir. I am a software developer with DB for 8 years. I can work by full time for your project and trying to satisfy the requirements. I want to keep a long-term relationship for customer so I want to give a nice r More
Ready to start the work on your requirement with immediate effact , we can discuss more over chat, thanks regards Arjun singh.
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. I will start immediately and complete it within a few hours. I More
Hi. I have considerable expertise in the design and development of MS Access databases. I have read the project details and the attached sample excel file. I believe a user friendly MS Access database would be perfect More
Hi, hope you're enjoying the summer in Ireland. I'm always keen working on projects that have to do with odds and statistics. This project seems simple enough and automating it will save you a lot of time. Can't imag More