Find Jobs
Hire Freelancers

Develop query in Microsoft Access that selects X number of random records per Y variable.

$10-4000 USD

Completed
Posted over 8 years ago

$10-4000 USD

Paid on delivery
Develop query in Microsoft Access that selects X number of random records per Y variable. Example: We have a table that track orders per Employee. The query would randomly select 10 orders per Employee.
Project ID: 9214333

About the project

9 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

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:
User Avatar
Sir/Madam, I am interested in your project. I have excellent expertise in Microsoft Access database and also good knowledge about SQL queries. I can help you develop queries which can help you accomplish the purpose. I also have good knowledge of VBA programming. I will accomplish your objective in following means: First I will query your database with employee names and all the orders. Then, using random sampling in programming, I will randomly select only 10 orders for each employee. I am confident of accomplishing the objective. Please consider my proposal and discuss with me your detail requirement. I assure you my complete support and service. Thank you, Yours faithfully, Saravana Prakash
$25 USD in 1 day
4.8 (11 reviews)
4.4
4.4
9 freelancers are bidding on average $130 USD for this job
User Avatar
Hello I am an exclusive MS Access developer completely dedicated to this platform - I do not work on any other database. I am also among the top three MS Access developers on this site. You can verify by going to https://www.freelancer.com/freelancers/skills/Microsoft_Access/ In order to do this you will need to create a dynamic query (a query that modifies the design of a basic query in the database using VBA), I look forward to hearing from you. regards Rajiv
$50 USD in 1 day
4.9 (154 reviews)
6.8
6.8
User Avatar
I have developed numerous systems in Access (utilizing VBA). I have developed a wide range of systems from small systems used by non-profits to average size systems used by small/medium business as well as enterprise systems being used by a Fortune 50 company. I have all the necessary experience and feel that I would be a perfect fit for your project. I would be more than happy to discuss your project as well a go over my experience and demo some of the systems I have built or am building. I hope to hear from you. Background: I am a software developer with 12+ years experience. I am currently consulting for a Fortune 50 company doing work primarily in Access and Excel with VBA. I have extensive experience in other aspects of software development as well. I am employed full-time, for the last 5 years, doing .NET development. I have built several large enterprise solutions during this time. I am very knowledgable in the following: .NET, VB, C#, HTML, javascript/jQuery, SQL, Access, Excel, VBA, Flash, Actionscript, PHP. I am new to Freelancer but am trying to build a solid profile. If you would like to talk before awarding this project let me know. Hope to hear from you.
$277 USD in 5 days
4.1 (14 reviews)
5.8
5.8
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
4.6 (30 reviews)
4.5
4.5
User Avatar
Request you to share the access file to analyze and confirm. You can award and pay when you see visual confirmation through teamviewer. ~Neo
$300 USD in 1 day
5.0 (5 reviews)
3.6
3.6
User Avatar
Dear client, I have a lot of experience with VBA and Access. Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA
$100 USD in 3 days
5.0 (3 reviews)
2.9
2.9
User Avatar
A proposal has not yet been provided
$34 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
1. 3 year of extensive experience in Database(modelling, creation) 2. Rich experience in writing complex SQL queries to create tables, views etc. 3. Extensive experience in writing PL-SQL queries for procedures, functions etc. 4. Completion of task on or before time. 5. No compromise policy with quality of work. 6. High preference for customer satisfaction.
$111 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Henderson, United States
5.0
11
Payment method verified
Member since Aug 2, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.