Date Querry Help!!!!! Please!

[Kyron]

The guy that does this isn't here ...

Can anyone tell me how I can write a querry that will check a date field for
all dates from the current year into the future?

I would be eternally grateful!

 

[Brian Camire]

Set the criteria for your date field to something like:

 

[[MVP] S. Clark]

Select * from TableName WHERE Year(YourDate) >= Year(Date())

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Kyron]

This is great but for some reason it is only giving me dates in 2003 and
2004, any idea why? There are about 100 records that have dates 2005 and
above, I am missing those.