Wildcard Dates in a Parameter Query

[Lisa S]

Hi

I have created a parameter query which queries a date field with the criteria Between [Enter Start Date] and [Enter Finish Date]. The question is, how do I tweak this so if all of the dates were required I could just click OK to the 2 input boxes and not enter any criteria and this would return all of the records. If I do this at the moment I get no records returned.

Thank you in advance

Lisa

 

[ColinEssex]

Hi Lisa

Here's how to do it.

Leave your criteria as it is in the first line of the query grid criteria then on the second line underneath it put this

Like [Enter Start Date] & "*"

What will happen is that if you leave the parameter boxes empty it will pick up all the records or is you put a start and end date in the boxes it will pick only those dates as normal.

Hope this helps. Let me know if you still have probs

Col

 

[Lisa S]

Works perfectly - easy when you know how - thanks ever so much!