Incrementally Generating A Date and Value Between Two Dates

[engelwood]

There's a whole back story as to why I need this functionality, but for brevity, I'll leave it out.... I have two columns A (the date) and B (the value). I would like to build a query to generate an incremental date and value for any dates between. I'll provide an example:

Current:
Column A Column B
1/2/15 1001-1002
1/4/15 1001-1002
1/5/15 1003
1/6/15 1003
1/9/15 1004-1005
1/13/15 1004-1005

The Desired Output:
Column A Column B
1/2/15 1001-1002
1/4/15 X
1/4/15 1001-1002
1/5/15 1003
1/6/15 1003
1/9/15 1004-1005
1/10/15 X
1/11/15 X
1/12/15 X
1/13/15 1004-1005

Thanks in advance... This will be a big help to me!

 

[cyrilbrd]

Hi,
given the following:

Excel 2013
	A	B	C	D	E	F
1	date	value			date	value
2	1/2/2015	1001-1002			1/2/2015	1001-1002
3	1/4/2015	1001-1002			1/3/2015	x
4	1/5/2015	1003			1/4/2015	1001-1002
5	1/6/2015	1003			1/5/2015	1003
6	1/9/2015	1004-1005			1/6/2015	1003
7	1/13/2015	1004-1005			1/7/2015	x
8					1/8/2015	x
9					1/9/2015	1004-1005
10					1/10/2015	x
11					1/11/2015	x
12					1/12/2015	x
13					1/13/2015	1004-1005
engelwood

formula in E2 is =A2
formula in E3 is =IFERROR(INDEX($A$2:$A$7,MATCH(E2+1,$A$2:$A$7,0)),E2+1) copied down till required.
formula in F2 is =IFERROR(INDEX($B$2:$B$7,MATCH(E2,$A$2:$A$7,0)),"x") copied down till required.

Would that be close to what you required?

 

[engelwood]

The output is correct, but I'm really looking for an access solution. The data is housed in access and will be changing on a weekly basis.

 

[cyrilbrd]

My bad, overlooked forum questions. will check with access.