|Select * From TableName where StartDate > #4 April 2010# and StateDate < #4 July 2010#"|
The # tells the SQL parser to treat the characters between as a date.
Select * selects all fields in the table.
Or you could put the dates into date variable and use it like any other variable.
I cannot guarantee that this query will work as is. You may have to mess about with the punctuation a bit.