Show Bid Request
MS Access 2000
Bid Request Id: 13383
|
|
|
|
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
|
|
|
|
|
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 |
|
|
|
|
|
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 |
|
|
|
|
|
|