Create database query

Ditutup Dipasang 3 tahun yang lalu Dibayar saat pengiriman
Ditutup Dibayar saat pengiriman

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.

MySQL Pemrograman Database SQL Perancangan Perangkat Lunak Excel VBA

ID Proyek: #25754039

Tentang proyek

46 proposal Proyek online Aktif 3 tahun yang lalu

46 freelancer rata-rata menawar €474 untuk pekerjaan ini

asin1987

WILL DO THE JOB IN NO TIME. Dear Employer, I understand you need to compare the horses daily data with your Database and produce results. Please message me, I will do the job in no time. We can talk about price if ne Lebih banyak

€500 EUR dalam 2 hari
(223 Ulasan)
8.1
sr33raj

Hello, I can develop a database oriented system for your horse race needs. Let me know when we can discuss. Thanks

€750 EUR dalam 20 hari
(585 Ulasan)
7.6
gopalvora

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

€500 EUR dalam 7 hari
(302 Ulasan)
8.0
zekovicm

Hi there I also have lot of experience with scraping betting/sports data and storing that in the database and creating different queries from it. Please feel free to initiate the chat so that we can discuss further de Lebih banyak

€450 EUR dalam 4 hari
(51 Ulasan)
7.1
pofilippov

Hello. I can do your project. About me: — 9+ year of experience. — Any tasks — Improve your ideas

€500 EUR dalam 8 hari
(39 Ulasan)
7.2
sloker18

With respect to this project I would like to present myself as a candidate for your consideration. I read your project descriptions carefully. I checked the attached workbook as well… I am proficient with Microsoft Exc Lebih banyak

€500 EUR dalam 5 hari
(96 Ulasan)
6.7
mateenbhatti94

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, Lebih banyak

€500 EUR dalam 2 hari
(64 Ulasan)
7.0
VladimirLilenko

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? Lebih banyak

€300 EUR dalam 3 hari
(93 Ulasan)
6.2
tutulsoft

--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

€250 EUR dalam 7 hari
(62 Ulasan)
6.3
BitSDestiny

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 Lebih banyak

€250 EUR dalam 15 hari
(47 Ulasan)
5.9
Martin718

Thanks a lot for taking your valuable time to read my message. After browsing your job description, I am very interested in your project and I believe I’m qualified for the task. Regarding Database Query, I have +8 ye Lebih banyak

€500 EUR dalam 7 hari
(2 Ulasan)
4.7
irfanui

Full Stack Engineer Hey everyone , I'm Mohammad Irfan , very hardworking and dedicated to my work. I always deliver what i promise to my clients. we done our work with a lot of proficiency , as well as at the accurate Lebih banyak

€750 EUR dalam 7 hari
(4 Ulasan)
4.7
janelka1991

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 Lebih banyak

€500 EUR dalam 7 hari
(3 Ulasan)
4.4
dat2na

Greetings, I'm professional database and BI expert with 12+ years experience. Currently I'm working as Senior DW, BI & DB developer in one of the leader financial corporation. As you can see in my profile page, I have Lebih banyak

€833 EUR dalam 2 hari
(4 Ulasan)
4.4
WizeDev

Hi sir, Thank you for reading my proposal. Yes I think I can automate this workflow for you. I'll scrape the data and save the result in sqlite local database then I compare the new data with the old and I produce a Lebih banyak

€400 EUR dalam 7 hari
(5 Ulasan)
4.1
vinod00k

Ready to start the work on your requirement with immediate effact , we can discuss more over chat, thanks regards Arjun singh.

€300 EUR dalam 7 hari
(4 Ulasan)
3.7
MonisZafar

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 Lebih banyak

€250 EUR dalam 1 hari
(11 Ulasan)
4.2
dionisiotumbaga

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 Lebih banyak

€250 EUR dalam 7 hari
(7 Ulasan)
3.7
aap31374

I have more then 15 years of experience in SQL Server databse design, modeling, development and Administration. I have worked with medium to large mission critical databases. Worked for database design and performan Lebih banyak

€444 EUR dalam 2 hari
(6 Ulasan)
3.3
pierrenortje

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 Lebih banyak

€400 EUR dalam 5 hari
(2 Ulasan)
3.0