Using a wildcard with "Between" Operator

[Sonny Jim]

I am using a parameter query to obtain data within a date range using the "Between" operator. There may be an occasion where a user may not want to filter by date at all. Is there a way to override this by using:

Like "*" & [] & "*"

...or by using a wildcard?

 

[vbaInet]

I am using a parameter query to obtain data within a date range using the "Between" operator. There may be an occasion where a user may not want to filter by date at all. Is there a way to override this by using:

Like "*" & [] & "*"

...or by using a wildcard?

You should implement a form instead.

 

[Brianwarnock]

Read this thread.

Brian

 

[Sonny Jim]

Thank you very much guys! I had no idea I could do something like that! What a nice tool!!!

 

[vbaInet]

You're welcome. Just for the curious minds and for the benefit of those reading this thread, what approach did you take?

 

[Sonny Jim]

Though I haven't implemented it yet, I am anxious to try using a form. I'm sure I will come up with many other uses for this as well. Thanks again!

 

[vbaInet]

Good luck. Any problems, you know where to come for advice.