all dates with month greater than equal current month

[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

 

[Rick Brandt]

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

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

 

[tlyczko]

Thank you!! That was a very quick reply!!
tom

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