MS Access SQL Query Help to Find Concurrent Bookings

$10-30 USD

Closed

Posted

over 7 years ago

$10-30 USD

Paid on delivery

Hi. I have an MS Access database. It's for a company that rents out equipment. I need to build a query that works out if equipment is overbooked on any date. For example let's say we run a query for the next 7 days & we have 2 units of a products for rent. If 2 units are booked Monday, Tuesday & Wednesday, that's no problem. If 1 unit is booked Monday, 3 on Tuesday & 1 on Wednesday then we are going to run out on Tuesday. I need a query that will tell me we'll be 1 unit short during the week. I can send the database too if needed but it's split so you might have to re-link the tables etc. I need someone who's available right now. Let limit it to a maximum of 1 hour work. We'd probably need to use live text chat.

SQL

Project ID: 12259508

About the project

12 proposals

Remote project

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

12 freelancers are bidding on average $25 USD for this job

@dghq123

Hi there.. I have read your project details completely and willing to do it for you... Check my recent reviews for our quality work on on time delivery Please inbox and we can discuss about project...

$25 USD in 0 day

5.0

(2 reviews)

3.0

@ZishanChuhan

Hi, I am expert in SQL, DB Design,DB Modeling, and Oracle Certified Professional. Can dot the task as per your requirements.

$30 USD in 1 day

4.5

(7 reviews)

3.2

@nithyarajeshg

I would like to let you know that i have enough experience in getting this done. My work strategy is to give regular status updates and intermediate versions whenever required.

$30 USD in 3 days

4.8

(4 reviews)

1.3

@QudratAli

Hi, I do have ample experience in SQL scripting and ready to do it for you. Lets chat and do it right away . Regards, Qudrat Ali

$25 USD in 0 day

0.0

(0 reviews)

0.0

@Ragust

Hello It's not problem, I'm sure that I'll impress you I hope that you choice me is a pleasure help you!

$25 USD in 1 day

0.0

(0 reviews)

0.0

@vivirain

Hi there, I'm interested in the job and can start working right now. Feel free to contact me and discuss more details. Best Regards , VL

$27 USD in 1 day

0.0

(0 reviews)

1.8

@SergeyKyiv

Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA: databases, finance, statistics, accounting, CRM etc. Any code I provide is well structured and commented, client gets whole access and rights for the code I made. Warranty covers any bugs detected later. I will rather need the database to test the query. Alternatively I would need structures of all tables involved. Also, I need to know the way you need to specify the margins of the time period to query: it might be a form's field or simply a parameter to enter malually. Looking forward for further clarifications of the details. Regards, Sergey

$25 USD in 1 day

0.0

(1 review)

0.0

@im146

Hi, i have experience in developing complex queries and databases on various platforms from around 5 years, i am interested in this task, please ping me so we can discuss it further and can start the work. Thanks,

$25 USD in 1 day

5.0

(1 review)

0.0

@gmuthukannan

Hi, I'm a software developer with more the 5 years of experience widely dealing with Sybase and SQL database development. I also have strong knowledge in software development and Software life cycle. I would be able to complete the task in less than an hour, if awarded. Looking forward to work with you. I'll be online for another 3 -4 hours. If you contact me after that I'll respond asap. Thanks, Muthu

$15 USD in 1 day