Search form with ranges

I want to be allow users to search ranges for dates and price and pull back related records from a form. For example, the user can search all values of over $500 or all dates between 12/30/02 -12/30/03. Not sure on the code or where to put this. I believe it would be 2 txt boxes for each but still want users to be able to search one specific date if needed. Does this have to 3 seperate txtboxes for date?

Hlp pls.

For Date range two seperate boxes. If they only want one date the enter the same date in both text boxes

S-

In the criteria section of the query for the search I have the following code (referring to user input):

Like [Forms]![SearchTestExpand]![EffDate]

How do I modify this code to allow for ranges (2 entries of date)? Would it be something like:

Like [Forms]![SearchTestExpand]!Between([EffDate] and [EffDate2])

Note:
EffDate = first textbox
EffDate2 = second textbox
for range of dates

Hlp pls!

Between [Forms]![SearchTestExpand]![EffDate] and [Forms]![SearchTestExpand]![EffDate][EffDate2]

S-