Find Jobs
Hire Freelancers

MS Access: Near Join

$30-250 USD

Cancelled
Posted almost 8 years ago

$30-250 USD

Paid on delivery
I have 2 fields in the Input table: Dates and MissingDate. In the MissingDate I have missing values. I would like to the code to fill the missing values with the nearest value. The preferred output table is and new field NewDate is in teh Output table. This is what teh table should look like after teh code is run. Example: 1/15, 1/16 and 1/17 have null values in MissingDate. The next date with a value is 1/18/16. So I would like the code to create a copy of missingdates table and fill in the missing values with the nearst date with is 1/18/16.
Project ID: 11016077

About the project

25 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
25 freelancers are bidding on average $91 USD for this job
User Avatar
Hi, Will VBA code work for you? Actually, I am not sure is it possible to do it any other way. :) Regards, Branislav Mihaljev
$155 USD in 3 days
5.0 (291 reviews)
7.8
7.8
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database table. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Access database and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can send you a sample of my previous work upon request.
$90 USD in 2 days
4.9 (215 reviews)
7.6
7.6
User Avatar
Have sent you the solution file cia messenger board. Let me know if you find any bugs. regards Rajiv
$50 USD in 3 days
4.9 (154 reviews)
6.9
6.9
User Avatar
Hi Mr. Employer I can do this project in effective manner with 100% accuracy report accuracy report to your requirements. Pm me for more information and sample as well. Thank you very much for your opportunity to bid RoyalCalif
$60 USD in 2 days
4.9 (89 reviews)
6.3
6.3
User Avatar
Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. In my portfolio look at the screen of "Create sales and purchases database application". You can have a little view about my coding experience.... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$155 USD in 3 days
4.7 (64 reviews)
6.4
6.4
User Avatar
Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA. Looking forward for further clarifications of the details. In particular I'd like you to choose the way to start the creating a new table: - a button on some dashboard - a query to run - a macro to run Regards, Sergey
$30 USD in 1 day
5.0 (9 reviews)
4.6
4.6
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with MSOffice every day. I have much experience with spreadsheets, formulas, databases and macros. Check my reviews. They speak for themselves. Best regards
$100 USD in 1 day
5.0 (10 reviews)
4.3
4.3
User Avatar
A proposal has not yet been provided
$30 USD in 0 day
4.9 (30 reviews)
4.5
4.5
User Avatar
This query is done using VBA code It will delete the output records, copy the records from input to output set the nearest date field from the missing field to the newdate field in Output I have good VBA programming and MS Access skills.. I can show you the output snaphot, if you require it today.
$30 USD in 0 day
4.8 (13 reviews)
4.5
4.5
User Avatar
A proposal has not yet been provided
$100 USD in 7 days
4.8 (11 reviews)
4.0
4.0
User Avatar
Hello, I would like to work with you on this project. I have so many years in software development, if you wish please see my profile. I am currently available and can start immediately. I have read your description and I see that It is easy to fix this date issue. We can do it using VBA (or C# if you prefer). If you have any questions or have a suggestion for me to make my bid better suite your needs, please let me know. Thank you. Regards, EK MCP (Microsoft Certified Professional), MCAD (Microsoft Certified Application Developer) and MCT (Microsoft Certified Trainer)
$35 USD in 3 days
5.0 (7 reviews)
2.8
2.8
User Avatar
Good day You have a interesting request and I believe I have already formed a couple of ways how to perform it with the outcome that you require. One of which is a lookup of the "closest date" and add a variable with this date which will be used for the NewDate, until a new "closest date" is found in the field and thus replace the variable, thus performing the task as required. I would definitely like to work on this for you and look forward for your correspondence. Regards Martin Botha
$50 USD in 3 days
5.0 (1 review)
1.1
1.1
User Avatar
Hi, I'm an electronic and computer engineer with expert knowledge of Microsoft Access and VBA programming. I reviewed specification You gave and I'm very interested to work on your project. I can assure You that,if You choose me,the project will be done in specified time frame and it will met quality recommendations. Thank You, Goran Hristov
$30 USD in 3 days
5.0 (2 reviews)
0.0
0.0
User Avatar
Hi, I have 24 years experience developing MS Access Application. I am easy to work with and my quality is 2nd to no one. I look forward to hearing from you! Best Regards Dave Stuart
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I am sam though I am new to freelancer but have worked at upwork from 6 years. I have a team of developers who will deliver the task within your timings Plz give chance Thanks
$277 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This sounds like a fun exercise. I believe it could be done with one or more Access SQL query/ies. I would provide the query, run and test as the solution.
$60 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Experience
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Saipan, United States
5.0
156
Payment method verified
Member since Mar 30, 2012

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.