Fill in cells between specific date range in Microsoft Access

Tags:
Microsoft Access
I have a file where customer's terms changed on a specific date to a specific value. I would like this value to populate for every day until the next change. For example:
Customer 12345 was changed to term A on 1/1/2015.

Customer 12345 was changed to term B on 2/5/2015.

Customer 12345 was changed to term C on 3/13/2015.
I would like a record created everyday for customer 12345 for the entire year. However from 1/1/2015 - 2/4/2014 customer 12345 should show a record everyday with term A. f or 2/5/2015 - 3/12/2015 customer 12345 should show arecord every day with term B. from 3/13/2015 customer 12345 should show term C every day for the remainder of the year. The columns I want would be customer, term, MMDDYYYY. If I have 1 customer, I will have 365 records. If I have two customers, I will have 730 records, etc.


Software/Hardware used:
Microsoft Access
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: