date difference

[bretch]

Hi,
I have here a situation wherein i have two date fields a "start date" and an "end date". I would like to have a third field in the same table that would automatically store the date difference of the two fields in minutes...
How will this be done? Any help is highly appreciated....
thanks

 

[Pat Hartman]

There is no need to store the difference when you can calculate it so easily in a query or on a form or report. Just use DateDiff().

 

[bretch]

thanks Pat,

it worked on forms and reports.
Just curious about it, is it possible to store the difference in a third field? how

bregs

 

[namliam]

As a general rule NEVER store calculated values.....

Regards

 

[Pat Hartman]

Of course it's possible. You can update the calculated field's value in the BeforeUpdate event of a form or your can run an update query. Neither method is recommended.

 

[bretch]

pat & namliam,

thanks for the inputs.....