date/ time stamp issue

[GoodLife22]

I have a field labeled [RecordDate] which saves date and time. I am setting up a query and I want to see all records for a set date range of

Between #7/1/2010# And #9/30/2010#

IF I use this criteria expression for the field [RecordDate]it will drop off all records from 9/30/2010 because they are truly 9/30/2010 8:55:45am ect.

I tried:
RecordDate2: Format([RecordDate],"mm/dd/yyyy") to drop the time stamp and added the criteria Between #7/1/2010# And #9/30/2010# to that field but no records are returned.

What can I do here?

 

[boblarson]

In your query just create a new column:

DateForRange: DateValue([RecordDate])

And then apply the criteria there.

 

[GoodLife22]

Field: DateForRange: DateValue([RecordDate])
Criteria: Between #7/1/2010# And #9/30/2010#

Error:
"Data type mismatch in criteria expression."

 

[GoodLife22]

This seems to take care of it.

Field: RecordDate
Criteria: >=#7/1/2010# And <#10/1/2010#

Can you see anything wrong with this set up?

 

[boblarson]

This seems to take care of it.

Field: RecordDate
Criteria: >=#7/1/2010# And <#10/1/2010#

Can you see anything wrong with this set up?

No, it should be fine.