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\[login to view URL]), 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\[login to view URL]), 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)