query to tell number of months between two dates

[Guest]

is there a way to tell the number of months between 2 dates
for example

Date 1 Date 2
3/1/2006 11/1/2007 = 20 mos

 

[Tom Ellison]

Dear DLB:

Please see the help for the DateDiff function.

Tom Ellison

 

[Guest]

DateDiff("m",#3/1/2006#,#11/1/2007#)

or

DateDiff("m",[Date 1],[Date 2]#)