Find Jobs
Hire Freelancers

Create an Access Table that "auto-Populates" with Dates

$10-30 USD

Completed
Posted about 7 years ago

$10-30 USD

Paid on delivery
I need a table that will “auto-populate” with dates (Months) based on some input by the user. The table will have four fields: AutoNumber, PID Number, Month and Year. The user will Select a PID. The PID (Proposal Number) will already exist in another Table. In a Field on a Form, Query… the User will enter a Start Date and Number of months What I need, in the Month Field, is the aforementioned Date plus 1 (the equivalent of one Month) Example: If the User entered January 01, 2017 the first Month record would be 2/1/2017 In the Year field, I need the Equivalent Year of the Month in the same record (i.e. 1/1/17 would be 2017) The User must be able to go back and make changes to the Start date and the number of years. I would assume it would have to back to the table and find and replace the records for the Assigned PID. PID: Z00026A-APCH-NF-1701 Start: 1/1/2017 Number of Months: 60 Record One would be: 1, Z00026A-APCH-NF-1701, 2/1/2017, 2017 Record Two would be: 2, Z00026A-APCH-NF-1701, 3/1/2017, 2017 And so on until there are Sixty records. Need someone who can think outside the Box.
Project ID: 13029413

About the project

12 proposals
Remote project
Active 7 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
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
12 freelancers are bidding on average $35 USD for this job
User Avatar
Hi, I'm a professional Microsoft Access and VBA developer with strong background in developing and modeling information systems using Ms Access. I have read your project description and would like to help you fulfilling your needs. I have done similar projects before, check my profile for details. I'm looking forward to hearing from you. Regards,
$35 USD in 1 day
5.0 (13 reviews)
4.3
4.3
User Avatar
A proposal has not yet been provided
$20 USD in 1 day
4.8 (10 reviews)
4.2
4.2
User Avatar
Hello, dear sir! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
$30 USD in 1 day
4.7 (20 reviews)
4.0
4.0
User Avatar
Hello, I will deliver windows application based on your requirements. We will deliver quickly. Thanks, Sheik
$23 USD in 1 day
5.0 (8 reviews)
3.5
3.5
User Avatar
Hi, clear requirements. I am starting a sample. windows application. simple forms. access database (2016) please initiate a chat to discuss further. Thanks
$23 USD in 1 day
5.0 (7 reviews)
3.0
3.0
User Avatar
Hi, I am interested to work with you. Please contact me on chat, I am waiting for your response. Thanks Sajib.............................
$25 USD in 1 day
4.9 (4 reviews)
2.4
2.4
User Avatar
Hi. I am an expert in VBA, VBScript, Visual Basic, C#, Access. I can create auto scripts to scrape websites, format txt, csv, xls, xlsx, doc, docx, database files as you request. I can start right now
$35 USD in 1 day
5.0 (2 reviews)
2.1
2.1
User Avatar
Hi.. I am a C# .net developer.. I have expertise in manipulating tables of Access using C# which is a windows form application. I have read the description and will be able to do the task.. We can discuss more over chat.. Looking forward to work with you..
$30 USD in 1 day
5.0 (1 review)
1.0
1.0
User Avatar
I will create access based application for you and if you want i convert access db into exe for your database security.. Once you share your exact requirement with me then i will give you some more suggestions to automate your entire process.. And this access application can generate customized reports as per your requirement.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Altamonte Springs, United States
5.0
22
Payment method verified
Member since Jan 5, 2017

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.