Access Between Query

Hello …

I am running a query in Access that is looking to pull data between 2 dates (Jan 1, 2010 to Dec 31, 2010).

This is the query I have but yet is it still pulling from other years. Please help … I have no idea what I am doing wrong

SELECT * FROM tasks WHERE JobSize = “Small” AND
(CreationDate between #1/1/2010# AND #12/31/2010#);

open up your table in Design View and have a look at the column definitions

what type of column is CreationDate?

Well thanks Rudy … The column was text.

So simple … Thanks again.