Form - Count Number of days (1 Viewer)

[sundaram]

Dear Friends,

I have table which has:

TblResult
fields are

Fields Date Type
Docmentdt as date
Description as Text
Submitteddt as date
Replydt as date
NoofDays as Number

Now, I want see in Noofdays column that total days if the submitted date is entered, for example: If i enter submitted date as 01-06-09 then in number of column it should from 01-06-09 to current date, if the current date is 10 then it should show 10 days).

After few days the concered document is return back to me date say 16-06-09. Then it should count (Replydt-submitteddt) result in the NoofDays column updating the cell (15 days).

When i vew in the form.

And also when i view report should updated data should be shown.

I hope you have got my point.

Please help me out.

 

[Poppa Smurf]

Have a look at the function DATEDIFF