Ok, this should probably be easy, but I seem to be making everything hard these days. I know the month, but I want to know what the last day of that month is. I am provided the month, but I want to build an SQL statement that extracts everything that has a date in that month. The only way I know how to do it is:

Select * From TableName Where CreationDate >= #1/1/2001# and CreationDate <= #1/31/2001#

Any ideas or suggestions?

Thanks