How Software Gets Done  


Login

Software Buyers
Request bids
Search coders
My Buyer Account
Buyer help
Buyer articles
Buyer FAQ
Latest news
 
Software Coders
Newest open work
Browse all work
Search all work
My Coder Account
Coder help
Coder articles
Coder FAQ
Latest news
 
Affiliates
My Affiliate Account
Affiliate help
Affiliate FAQ
Latest news
 
Newest Bid Requests.
(See all)
Palpal / Stormpay Clone
By rohit123 on Aug 14
Max Bid: Open to fair suggestions


Windows DDK for Ethernet/SCSI combo card
By ScalePort on Aug 14
Max Bid: Open to fair suggestions


Car dealer integrated with ebay motors
By rozsa2 on Aug 13
Max Bid: Open to fair suggestions


Check Connector
By AL9045 on Aug 13
Max Bid: $15


Linux device driver + File System Modification + A ...
By ScalePort on Aug 13
Max Bid: Open to fair suggestions


Hide windows process
By lwinkenb on Aug 13
Max Bid: Open to fair suggestions


Click here to put this ticker on your own site and/or get live RSS newsfeeds

Open Work Categories.
Database 
(182 open)
   Access 
(58 open)
   MySQL 
(90 open)
   Oracle 
(11 open)
   SQL Server 
(61 open)
   Other DB 
(24 open)
Documentation / Tech Writing 
(24 open)
   Language (Human) Translations 
(3 open)
Data Entry 
(29 open)
Game Development 
(19 open)
Graphics / Art / Music 
(54 open)
   Graphics 
(64 open)
     Adobe AfterEffects 
(7 open)
     Adobe Photoshop 
(37 open)
     Adobe Premiere 
(8 open)
     3d Animation 
(13 open)
   Art (Misc.) 
(19 open)
   Music 
(12 open)
   Photography 
(9 open)
   3d Modeling 
(8 open)
Language Specific 
(109 open)
   Assembly / Machine language 
(10 open)
   ASP 
(69 open)
   ASP .NET 
(55 open)
   C# 
(57 open)
   C++ / C 
(129 open)
   Carbon (Mac OS) 
(3 open)
   Cocoa / Obj-C 
(4 open)
   Cold Fusion 
(13 open)
   Delphi 
(52 open)
   Java 
(78 open)
   JSP 
(11 open)
   Perl 
(42 open)
   Python 
(4 open)
   PHP 
(91 open)
   XML/XSL 
(34 open)
   Visual Basic 
(145 open)
   Visual Basic .Net 
(91 open)
   Other 
(70 open)
Misc 
(40 open)
   CAD 
(5 open)
MultiMedia 
(36 open)
   Video Editing 
(6 open)
Network 
(45 open)
   Network Design 
(6 open)
   Network Implementation 
(13 open)
Platforms 
(64 open)
   Windows 
(201 open)
     MS Exchange 
(11 open)
     MS Office 
(16 open)
     Other 
(15 open)
   Darwin 
(1 open)
   Internet Browser 
(51 open)
   Linux 
(59 open)
   UNIX 
(17 open)
   Hand Held/PDA Programming 
(17 open)
Requirements 
(12 open)
Security 
(39 open)
Testing / Quality Assurance 
(20 open)
Web 
(198 open)
   Page Design 
(103 open)
   Flash 
(61 open)
   Web Services 
(83 open)
   Web (Other) 
(95 open)
Training 
(16 open)
   Computer Based 
(12 open)
Other
 
Other Sites

Download the free Rent A Coder IE toolbar!
 
Show Bid Request

MS Access 2000
Bid Request Id: 13383
Bookmark in my 'To Do' list
Posted by: dcraw999 (2 ratings)
(Software buyer rating 10)
Non-action Ratio: Very Good - 0.00%
Buyer Security Verifications: Unverified
Approved on: Apr 13, 2002
3:53:53 AM EDT
Bidding Closes: Apr 15, 2002
1:00:00 PM EDT
Viewed (by coders): 542 times
Deadline: 4/15/2002 6:00:00 PM
TIME EXPIRED
Phase:
100% of work completed and accepted. Coder has been paid.
Max Accepted Bid: Bidding is closed
Project Type: Personal Project / Homework Help
Bidding Type: Open Auction
Categories: Windows, Database, Visual Basic
Enter chat room for this bid request
(0 active users at Aug 14, 2003 3:55:34 AM EDT)

Description:
I have a database which contains a table with contains several columns. One column contains the names of MULTIPLE companies. Another column contains consecutive MONTH END dates - 19890131, 19890228,
19890331, etc. So the table contains monthly company data for multiple companies, but the number of
consecutive months vary just as the company names do. Some companies in the table might only have 5 months
of data (consecutive months) while other companies have over 100 months of data (consecutive months). I
want to pick a starting month and then have a program create a new table with a table name that I input containing all columns from the original table IF and ONLY IF the date column has 84 CONSECUTIVE months of data for any company starting with the month that I pick. For example, I have 50 companies and 120 consecutive months of data. If I choose month 1 (19890131), I'd like a new table created that would contain all of the companies that contain data (company name and all other fields in the table) for month 1 (the one that I input) AND also the next 83 consecutive months. Some companies might only have 50 months of data, so these would not make it into the new table. Some companies will have more than 84 months of data, but I only want 84 months total in the new table. That is, every company that "makes it" into the new table HAS to have 84 consecutive months of data, no more, no less. Being able to change the start date is important, I'd like to walk the start date forward or backward to create new 84 month tables, each with a different start date. I'd also like to be able to change the '84' to any other number of consecutive months that I choose so that I can create other tables with a fixed number of consecutive months where I choose/input the number of consecutive months. A MS Visual Basic program that runs inside or outside of MS Access 2000 (Windows 2000) is fine as long as I can 1) enter the database file location path and database name (such as c:\temp\one.mdb), 2) enter the table name, 3) enter the 8 digit starting date, 4) enter the number of consecutive months that I desire, 5) enter the output database name 6) enter the output database file path, 7) enter the output table name (all newly created tables should be able to be created in any existing database)

Deliverables:
I want to input an 8 digit starting date and then have a program create a new table with a table name that I input containing all columns from the original table IF and ONLY IF the DATE column has 84 CONSECUTIVE months of data for any company starting with the month that I pick. For example, I have 50 companies and 120 consecutive months of data. If I choose month 1 (19890131), I'd like a new table created that would contain all of the companies that contain data (company name and all other fields in the table - fields will vary if I switch to a different database) for month 1 (the one that I input) AND also the next 83 consecutive months. Some companies might only have 50 months of data, so these would not make it into the new table. Some companies will have more than 84 months of data, but I only want 84 months total in the new table. That is, every company that "makes it" into the new table HAS to have 84 consecutive months of data, no more, no less. Being able to change the start date is important, I'd like to walk the start date forward or backward to create new 84 month tables, each with a different start date. I'd also like to be able to change the '84' to any other number of consecutive months that I choose so that I can create other tables with a fixed number of consecutive months where I choose/input the number of consecutive months. A MS Visual Basic program that runs inside or outside of MS Access 2000 (Windows 2000) is fine as long as I can 1) enter the database file location path and database name (such as c:\temp\one.mdb), 2) enter the table name, 3) enter the 8 digit starting date, 4) enter the number of consecutive months that I desire, 5) enter the output database name 6) enter the output database file path, 7) enter the output table name (all newly created tables should be able to be created in any existing database)

Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

Complete copyrights to all work purchased.

I can email a sample (<1MB) database if required for testing.


Platform:
Microsoft Access 2000 (9.0.3821 SR-1)
running on
Windows 2000 (5.00.2195 Service Pack 1)

Must be 100% finished and received by buyer on:
Apr 15, 2002 6:00:00 PM EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.


Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.
 
Bidding/Comments:
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests.

See all rejected bids (and all comments)
Name   Bid Amount 
 
Date   Coder Rating  
Michael Sharp
(134 ratings)
in Ptolemaida, Kozani
Greece
Bid id: 148,202
This coder is certified! Click here for transcript
N/A Apr 13, 2002
5:14:07 AM EDT
 9.98
(Excellent)
   
Hi,

Thank you for the invitation to bid on your project. Would you mind sending me a sample of your database for review?

Regards,

Michael Sharp
 
 
 
 
  See 4 private reply(ies)
to/from Michael Sharp.
 




Bid Request Search
 Advanced Search
Newest Open Work
Latest News  
Credentials


 

 
Rent A Coder upholds the rigorous business practices required to be both a BBB member and Square Trade vendor.
  • All customer issues addressed within 2 days
  • Openly disclosed pricing and return policies
  • Participation in mediation at buyer request
  • Superior selling track record
This site is verified through its parent company, Exhedra Solutions, Inc.
 
Top Coders.

Anuj Gakhar
Rated a 9.97 on 105 jobs 
Securenext
Rated a 9.96 on 114 jobs 
Buddies
Rated a 9.83 on 85 jobs 
Andrei Remenchuk
Rated a 10 on 14 jobs 
Codman
Rated a 9.97 on 153 jobs 
Michael Sharp
Rated a 9.98 on 182 jobs 
D-N-S
Rated a 9.93 on 38 jobs 
markesh
Rated a 10 on 22 jobs 
teleCODERS
Rated a 9.93 on 67 jobs 
hernest
Rated a 10 on 116 jobs 

See all top coders...

(What makes a top coder?)

Top Exam Scorers

 
Other
Rent A Coder is PayPal verified through its parent company, Exhedra Solutions, Inc.

Created in partnership with:

 

Affiliate Sites
Latest News | About Us | Kudos | Feedback/Contact    Affiliates | Advertise    Privacy | Legal

Copyright © 2001, Exhedra Solutions, Inc. All rights reserved.
By using this site you agree to its Terms and Conditions.
"Rent A Coder" (tm), "Safe Project Escrow" (tm) and "How Software Gets Done" (tm)
are trademarks of Exhedra Solutions, Inc.