I have a query set up that displays various information and one of the fields is a date.
How do I go about setting up the criteria for the date field so the user can pull the query after selecting that they wanted it before or after a date they input in a text box or in between two dates they enter in two text boxes?
Between two dates can also be: Between #2 Feb 2006# And #2 April 2006#
The between operator is inclusive. the above espression is equivalent to: >= #2 Feb 2006# And <= #2 April 2006#
To do what you are asking, I normally use a custom dialog. The dialog has a from date and a to date and the user enters/selects one or both. Then, I build the required expression in VBA and pass that along to the form or report as a filter or as the record source for the form or report.