troubleshooting Question

Transferring payment arrangement to 2nd table with expected payment date (SQL & VBA)

Avatar of stkjobmb001
stkjobmb001 asked on
Microsoft AccessMicrosoft Applications
1 Comment1 Solution478 ViewsLast Modified:
Use code (not queries to perform the following)

I want to take data from the PAYMENT PLAN table and automatically populate a 2nd table, TRACK PAYMENTS, with data for each expected payment date.  I need to option to EITHER populate future payment dates OR populate back dates in the event that the application is used for a previous arrangment.  There may be several changes in a payment plan over time.

PAYMENT PLAN   (Input data for future)
Amt      Period           Beginning      Ending                              
200       month          01/01/2010     12/31/2015  (5 years)
100       month          01/01/2016      12/31/2016  (1 year)
50          month         01/01/2017       03/31/2017  (3 months)

TRACK PAYMENTS (auto populate table)
Amt              Date Expected
200                   01/01/2010    
200                   02/01/2010            
200                   03/01/2010              
200                   04/01/2010        
200                   05/01/2010        
200                   06/01/2010    .......  12/31/2015

100                    01/01/2016
100                    02/01/2016
100                    03/01/2016
100                    04/31/2016    ......  12/31/2016      
50                       01/01/2017 ...  03/31/2017  

PAYMENT PLAN   (Input data from past)
Amt      Period           Beginning      Ending  
200        month            01/01/2003     12/31/2008
100        month             01/01/2009     12/31/2009

TRACK PAYMENTS (auto populate table)
Amt              Date Expected
200                   01/01/2003    
200                   02/01/2003            
200                   03/01/2003              
200                   04/01/2003              
200                   05/01/2003   .......  12/31/2008

100                    01/01/2009
100                    02/01/2009
100                    03/01/2009
100                    04/31/20109   ......  12/31/2009        
ASKER CERTIFIED SOLUTION
MikeToole

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros