Count the days between 2 dates

[Samuel]

Is there a method that I can use in access that counts the days between 2
specified dates?

Thank you,
Samuel

 

[Guest]

Have you tried the DateDiff function
http://msdn2.microsoft.com/en-us/library/Aa262712(VS.60).aspx

 

[Allen Browne]

Use DateDiff(), e.g.:
DateDiff("d", [Date1], [Date2])

 

[fredg]

Is there a method that I can use in access that counts the days between 2
specified dates?

Thank you,
Samuel

= [Date1]-[Date2]
or
= DateDiff("d",[Date1],[Date2])