Find the Value of Two dates!!

[nishet]

I am using access 2000. I am aware their is a field called DateDiff.

I have two fields one is HolidayStartDate and the other is HolidayEndDate. I want to work out in the third field the Total NumofDays, this 3rd field should be automatically displayed with an answer once field 1 and 2 have been entered. Please can you show me how to write the sql query.

Cheers Nish
Programmer

P.S. Please show me, using the fields I have provided.

1) HolidayEndDate
2) HolidayStartDate
3) NumOfDays

 

[Cagliostro]

update yourTableWithHolidays
set NumOfDays = datediff(d, HolidayStartDate, HolidayEndDate) John Fill

ivfmd@mail.md