he guys,

 I nave create an table with DATE OF CALL BOOKED & DATE OF CALL COMPLETED AND NO OF DAY'S taken and in the from i play the source data of the No of day's taken as =[DATE OF CALL BOOKED] - [DATE OF CALL COMPLETED]...

  It's working in the from but it is no storing in the table what is the reason for the above issue..and how can i store the data in the table ...

 Give me some codes..
 or
 exaples for this

 This is the long term Question for me...

Learn as you can..
------------------------
pap...

Hi,

   In the After Update, or Before Insert event of the second field, put this code:

Dim dtCallBooked As Date
Dim dtCallComplete As Date
Dim iDays As Integer

dtCallBooked = Me.Date_of_Call_Booked ' never use spaces in field names - Access will insert underscores in control names.

dtCallComplete = Me.Date_of_Call_Completed

iDays = DateDiff(dtCallComplete - dtCallBooked) 'I think that is right, or reverse the order

Me.No_of_Days = iDays

That should work. Let me know if it doesn't.



mmcdonal

Mc.. its not working

 I have stored in the from's after update but i doesnt works..
 what to do..



Learn as you can..
------------------------
pap...

Hi mc

I got the code.. this is wat i stated...

In the from.. before insert event i enter this code as what u said

Dim dtCallBooked As Date
Dim dtCallComplete As Date
Dim iDays As Integer

dtCallBooked = Me.Date_of_Call_Reported

dtCallComplete = Me.Date_of_Call_Completed

iDays = DateDiff(dtCallComplete - dtCallBooked)

Me.No_of_day_s = iDays.. i quit hard to uderstand..

then i tried this code with som altration in Data of completion get focus event

Dim dtCallBooked As Date
Dim dtCallComplete As Date
Dim iDays As Integer

If IsNull(Me.Date_of__Call_Completed.Value) = False And IsNull(Me.Date_of_Call_Reported.Value) = False Then
dtCallBooked = Me.Date_of_Call_Reported.Value
dtCallComplete = Me.Date_of__Call_Completed.Value
iDays = DateDiff("d", dtCallBooked, dtCallComplete)
Me.No_of_day_s.Value = iDays
End If

it works .. thanks for ur kind support donal



Learn as you can..
------------------------
pap...