1 SELECT SQL with subqueries in MS ACCESS

€8-30 EUR

Completed

Posted

about 4 years ago

€8-30 EUR

Paid on delivery

I need 'convert' (do a query select) db_size_test table to have the same as is in RESULT table. If there are 2 values in same day (DateTime) than pick MAX of Size per ClientID. This test is with only 1 ClientID - there can be more Client IDs and and more dates. Resul should be all days of current month with client IDs and Sizes. If there is was no Size in date take size from previous not null value. I need this in 1 SELECT QUERY with subqueries.

Microsoft Access

SQL

MySQL

Project ID: 23940309

About the project

21 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@salimnaja

straight forward query, i can provide you with a clear documentation on how its done so you do it alone next time without the need to pay for the answer.

€8 EUR in 1 day

5.0

(1 review)

0.0

21 freelancers are bidding on average €20 EUR for this job

@zu02

Hi I've viewed your Access DB. Very easy job. Simply now here very late and I can code it by tomorrow if awarded. Though if this very urgent I can do this tonight. Thanks, Zurab Ms Access/vb developer

€30 EUR in 2 days

4.6

(50 reviews)

6.1

@rohitagarberg

HI THERE, I WILL WRITE THE QUERY TO DISPLAY THE DATES AND THE TOP VALUE FOR DATE AND WILL MAKE SURE RESULT IS SAME AS THAT OF RESULT TABLE, WILL DO IN FEW MINS RIGHT NOW FOR 8 EUR, THANKS

€8 EUR in 1 day

4.9

(65 reviews)

5.2

@tutulsoft

SOLVE in HOURS!!! i am ready right now .... MS Access EXPERT with any type of complex Query . 20 years experiences ... ..can you connect me to start ...thanks

€24 EUR in 1 day

4.9

(11 reviews)

4.8

@jaedonfarrugia

Expert in SQL, placed in the top 3% of all freelancers globally. Lots of 5 star reviews related to SQL, MSSQL, t-SQL, etc. Ready to work right now. Please contact me if you are interested.

€20 EUR in 1 day

5.0

(6 reviews)

3.3

@igorshapo926

Hello, Nice to meet you. I can do it perfectly. please come to chat so we can discuss in details. Thanks.

€30 EUR in 1 day

5.0

(1 review)

2.8

@yarvynnychuck

Hi, I'm expert web-developer with 7 years of experience. I have rich experience with MS Access. Please contact me, I'll start right away. Best regards, Yaroslav

€19 EUR in 7 days

0.0

(0 reviews)

0.0

@jbayton2492

Hey there I can help you with your project. I have experience working with databases and other tools like vba, python and many others. Let me know if you want me to help you. Greetings

€34 EUR in 5 days

0.0

(0 reviews)

0.0

@RiazAnsari

hi sir, I will write the query for you for 10 EUR. I have 12 years of experience in the application development. thanks.

€14 EUR in 2 days

0.0

(0 reviews)

0.0

@atulkumar16

I can write your queries quickly and efficiently. With the vast experience on MS Access and specific to SQL Queries makes me different from general experts. I have worked with various top customer for their data queries, data migration, data analysis, data reporting and similar activities. Performance Tuning is my area of interest for query optimization.

€15 EUR in 1 day

0.0

(0 reviews)

0.8

@aashishware

I have worked in Ms access for stand alone softwares Relevant Skills and Experience C# .net Ms access

€23 EUR in 1 day

0.0

(0 reviews)

0.0

@VbaStudio

I know about queries in SQL language, and how to do what you need. ---------------------------------

€15 EUR in 1 day

0.0

(0 reviews)

0.0

@MinaAth

Hi, I have been studying and creating Databases for many years. I would be happy to assist. Looking forward to your response. Asimina

€18 EUR in 1 day

0.0

(0 reviews)

0.0

@Gurusamis

Hello, I have good Experience (8 Years) in the SQL Database query making. I can make the SQL query as per your requirements. Regards, Gurusami S.

€10 EUR in 3 days

0.0

(0 reviews)

0.0

@Hitesh27111991

hello, i have good experience to write sql query and total 6 year of experience on sql. if you are interested please contact me. thanks.

€30 EUR in 7 days

0.0

(0 reviews)

0.0

@sandeepd87

I will complete this task in 7 days with the help of Sub Queries and main Query. i has around 8 Years of Good Experience in SSMS. And came across these type of Complex Scenerios a lot of times..

€10 EUR in 7 days

0.0

(0 reviews)

0.0

@Bijayshruti

I have experience of 5 years in managing data. can easily work on access.....................................................................

€24 EUR in 2 days

0.0

(0 reviews)

0.0

@AlpaKaotekwar

I have worked on SQL server from last 2 years so able to do your in a best way so want to work on it, able to learn new things

€29 EUR in 3 days

0.0

(0 reviews)

0.0

@sachinkjadhav

Hello, I am having 15+ years of experience in development using databases. I have checked the MS Access database. I am confident that I can work on your requirements and deliver you the query, which will insert the correct result in the results table. Thanks

€8 EUR in 1 day