I would like to have a parameter query where a date range can be specified by the user and a state specified. For example give me all the records between date one and date 2 AND where state is NY. Also, the user may wish to not enter a date 1 or date 2. How can I write a criteria in the date field to handle the situation where date 1 and date 2 are left blank? Thanks Richard.

---

Reply from Richard Rost:

Optional parameters get VERY tricky; so much so that I can't go into details here. It involves a whole bunch of IsNull functions and checking for empty strings. I cover techniques to deal with this in my Search Seminar.