Datediff

[knocker]

I have 3 columns in a table date received and appointment date i'm trying to populate a 3rd column with the datediff anybody any idea how to do this

[Tanis]

use this SQL.

SELECT tblAppointment.DateRecd, tblAppointment.AppointmentDate, DateDiff("d",[daterecd],[appointmentdate]) AS DateDifference
FROM tblAppointment;

Gives the difference in days. Change the table and field names to suit.

[knocker]

where would i put this so it filled in the third colunm automatically when new data is put into the first two colunms

use this SQL.

SELECT tblAppointment.DateRecd, tblAppointment.AppointmentDate, DateDiff("d",[daterecd],[appointmentdate]) AS DateDifference
FROM tblAppointment;

Gives the difference in days. Change the table and field names to suit.

[Tanis]

Create an unbound text box on your form. In the On Current event, put this.

Me.txtDifference = DateDiff("d", [DateRecd], [Appointment])

Change the names to suit.

[knocker]

Thanks for your help