Create Date Range within a multi field search?

[kevin19]

For example, I have a few combo boxes and text boxes for my advance search. The search works fine.Is it possible to incorporate a range between two dates into my multi field search?
All these boxes are unbound.
Possible help??

 

[John Big Booty]

The short answer is yes, your criteria might look something like;

Between Forms!YourFormName!StartDateField And Forms!YourFormName!EndDateField

 

[kevin19]

Thanks John!
But does it work as I have 3 date fields in my multi search. Action date, compliance date and deadline. If I use your criteria how do we know which date field it is referring to?
I am not that clever!

 

[John Big Booty]

You will need to change the field names to reflect the reality of your DB. A Between argument can only be between two fields so you will need to decide which of those two fields you name.