Hello,

I'm writting a database for a dog & cat kennel, I need to know how many days
the pet has stayed at the kennel. I have two date fields named StartDate &
EndDate and have a field named TotalDays. I need this to go into a form.

Thanks

Robert
infomail at rcrawford dot biz

Use DateDiff function to get the number of days between the StartDate and
EndDate. You should not need to store the result in your table; just
calculate it on your form by using a textbox whose control source is an
expression similar to this:

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

--

Ken Snell
<MS ACCESS MVP>

"Robert" <infomail (AT) rcrawford (DOT) biz> wrote