Auto Calculate Field

[wordsmith]

Hi all,

I'm trying to set up a holiday register. In my holiday table i have the following fields HolidayID, PersonID, StartDate, EndDate. I would like to have a final field which auto-calculates the number of days taken between start and end date. I read somewhere this should be done in a query using the DateDiff expression but I can't seem to get this to work.

Any ideas please?

Thanks all!

 

[ColinEssex]

DateDiff("d",[StartDate],[EndDate])

Col

 

[wordsmith]

cheers for that Col,

but I'm not sure where that goes? is it entered as a validation rule in the field properties?

 

[ColinEssex]

Use it as a calculated field in a query

Col