Search results

I used it in the criteria of my field "SchedDate".

No fields named Date in my query, field name is SchedDate. I'll keep plugging away. Thanks for your help

Thanks to all for the quick replies. Bob, I tried the code you supplied and am getting "Ambiguous name in query expression". Any ideas? Thanks for your help.

I have a form with a combo box containing the names of the Months. What I want to do is then pass the Month name to a query as a date range. For example, select "May" from cboMonth and the query will check the date field for "between 05/01/2008 And 05/31/2008" Here is what I have in my query...