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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-