Query choice to pull all dates

[punter]

Hi,

I have some forms in my database that pull run various queries. They usually give the user two boxes to enter dates (start date and end date) of queries. They work great (thanks to much help from the people on this board).

Is there a way to have to enter something into the form that will tell the query to grab all records regardless of date? Example: I want to see records that end on date 03-18-07 but may run back forever. Is there something I can enter into the start date box (All, Everything, whatever) that will do this?

Maybe this is some kind of IfNull thing I have to put into the query?

I'm working on it. Any thoughts would be of much help.

Thanks

Eddie.

 

[boblarson]

Probably the best way is to build the query on the fly (several posts have been posted on how to do that) so that if it is filled in it takes the dates you selected and if not it takes all of them.

Now, that being said, the EASIEST method is just to have two queries and to call the appropriate one when you click the button; one if it has dates and one if not.

 

[punter]

Thanks so much Bob. That makes sense. I never know if I need a technical or theory answer. This time it was theory.

Thanks again.

Eddie.