all dates with month greater than equal current month

T

tlyczko

I'm trying to pull Access data for a web page.

I want a query that will pull all dates for the current month plus all
future dates.

For example, December 2006 onward to January or February 2007...

I've tried DatePart with Month but that only gives me December...

How do I write the query criteria for this month plus all future
months??

Thank you, :) tom
 
R

Rick Brandt

tlyczko said:
I'm trying to pull Access data for a web page.

I want a query that will pull all dates for the current month plus all
future dates.

For example, December 2006 onward to January or February 2007...

I've tried DatePart with Month but that only gives me December...

How do I write the query criteria for this month plus all future
months??

Thank you, :) tom
Click to expand...

SELECT *
FROM TableName
WHERE DateField >= DateSerial(Year(Date()), Month(Date()), 1)
 
Top