>I'm trying to scan a date field for records that are in the month of may 1999 is there a function or comgination of functions to do this?
>
>Any Help will be greatly appreciated!
scan while/for Month(mydate)=5 and year(mydate)=1999
HTH
Jeff
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com