Query Result By Month 2003

[Humbled Learner]

I have a table called Customer: First, Last, Phone
I have a table called Order: Date (set to date/time, To, From, Memo.

I have a Form Order, dropdown box with name, Date (=date()), To, From, Memo.

I have a query which reflects all information in both tables. (Date shows
like 9/29/2009)

Now, I would like to make a search form. When the form opens, you would
have to add the "Search From Date" and "Search To Date". Upon entering the
dates, I would like a query to open reflecting only the orders in that time
frame.
Say 01/01/2009 - 01/31/2009.

Am I missing info in my tables? forms? or can I walk through this with just
a query?

I'm not simple minded, but I have looked in the history and just can't seem
to put the bits and pieces together with no where to start from. I'm missing
something.

MS Help and "Limit the fields to data" didn't help much either.

Please throw me a bone, I'll email you a dollar... Just kidding of course.

 

[KARL DEWEY]

I have a query which reflects all information in both tables.
Post the SQL of that query by opening in design view, click on VIEW - SQL
View, highlight all, copy, and paste in a post.