text field that displays the values between txtVal1 and txtVal2

[BZeyger]

Hello,

I have a form that contains 3 text boxes.

txtVal1
txtVal2
txtValOf1Through2

txtVal1 is a start date
txtVal2 is an end date
txtValOf1Through2 is the date range between txtVal1 and txtVal2

I would like to have the txtValOf1Through2 textbox to display the values
between the start and end date.

If i input:

=[start] & " - " & [end]

it does not see the values data in between. I would like to use the gathered
information in a piviot table.

Thanks for your time

 

[John W. Vinson]

Hello,

I have a form that contains 3 text boxes.

txtVal1
txtVal2
txtValOf1Through2

txtVal1 is a start date
txtVal2 is an end date
txtValOf1Through2 is the date range between txtVal1 and txtVal2

I would like to have the txtValOf1Through2 textbox to display the values
between the start and end date.

If i input:

=[start] & " - " & [end]

it does not see the values data in between. I would like to use the gathered
information in a piviot table.

Thanks for your time

What are the "values" you want to see? All dates? Data from a table within
that range? It's not clear what you're asking.

 

[BZeyger]

I was look to display the duration of a project graphicly. I wanted to
display the points on a chart based on the start and end date.

For example:

Project 1 would show a highlited area of 1/1/09 through 2/1/09
Project 2 would show a highlited area of 1/15/09 through 2/9/09

I was using a chart to display the info. The left side of the chart would
show all of the projects. The Date range would be displayed for each project
it coresponds.

When I creat a chart (Piviot Chart) right now, I place the Projects on the
left side, and the Start date and End date on top. The chart does not display
properly. I thought that having one date field on top would show my desired
results.

Hello,

I have a form that contains 3 text boxes.

txtVal1
txtVal2
txtValOf1Through2

txtVal1 is a start date
txtVal2 is an end date
txtValOf1Through2 is the date range between txtVal1 and txtVal2

I would like to have the txtValOf1Through2 textbox to display the values
between the start and end date.

If i input:

=[start] & " - " & [end]

it does not see the values data in between. I would like to use the gathered
information in a piviot table.

Thanks for your time

What are the "values" you want to see? All dates? Data from a table within
that range? It's not clear what you're asking.