Displaying summary date range

[Jscott]

I have 2 related tables and on table 1 & 2 there are several dates that are entered. On Table two I want a layout to display the two dates (1 from table 1 and 1 from table 2)and next to it the number of days that have elapsed.

I just cannot seen to figure it out.

Thanks!

[Jscott]

Here is an example of my problem.

It works great the first time it calculates but go back and change a date and it does nothing.

Thanks,

Dates.zip

[comment]

Try using a calculation field instead of auto-entered calculation.

[Jscott]

Can you be a little more specific? I used the calculation by validation and no help.

Sorry I am clearly a novice at this ;)

[comment]

Change the field's type from Number to Calculation. Validation has nothing to do with this.

Sorry I am clearly a novice at this

Hm. Your profile say "Intermediate".

[Jscott]

Not working.....

Dates.zip

Edited September 1, 2009 by Guest

[comment]

It does work when you have data.