MS Access Query Problem

I am not experienced with Access nor am I good with VBA. I’m working with a construction project where two daily reports will be entered into dbase in order to mark progress and a bunch of other measurables. My superiors want to be able to look at the progress on a week by week basis. I am trying to query using the dates the inspectors type into the forms. The date is in date/time format.

The criteria I’m using on the form under date is Between [From] and [To]. I’ve created a dummy record in order to test the query at a date of 05/30/2007. I then try to query from 05/01/2007 to 06/15/2007 with that exact syntax and no records show up.