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

Thank you,
Samuel

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

"Samuel" wrote:

> Is there a method that I can use in access that counts the days between 2
> specified dates?
>
> Thank you,
> Samuel
>
>
>

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Samuel" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Is there a method that I can use in access that counts the days between 2
> specified dates?
>
> Thank you,
> Samuel
>

On Fri, 13 Jul 2007 15:39:52 +0100, Samuel wrote:

> 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])
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail