count days between two dates

[shelspa]

I have a parameter query that shows one record. It has fields for a beginning date and an ending date. I want to count the number of days between the two. Help appreciated.

 

[dhookom]

Because of the way dates are stored in Access, you can just subtract the earlier date from the later date to get the exact number of days. Each day equals 1 and partial days are percents. For instance 6:00 am adds .25 (1/4 of day).

I prefer to use the built-in date functions. In this case, try:
DateDiff("d",[BeginningDate], [EndingDate])

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[shelspa]

That worked great thanks.