I have pondered the following teaser for some time without getting a really acceptable solution:

Creating a parameter query using SQL for a MS Access (97) Database where I want to use wild cards in the parameter.

E.G. :

WHERE (((tblusage.DATE) Between [Type Start Date] And [Type End Date:]))

SQL does not seem to allow the use of wildcards in a parameter query involving dates.

I.E. If I wanted to search a table of records containing any day in the month of January in any year
Syntax using **/01/**** or ??/01/????

or any combination of static parameters and wildcards.

SQL throws up an error saying the query is too complex and has to be simplified or the syntax in the expression is incorrect.

I have checked through all the possible numeric wildcards that (Access97) SQL allows to be used and I can only find * and ? as legal characters.

My question is can this be done using SQL and if so does anyone know the correct expression?

If not, do I need to go down the VB route (VB for Applications code - MS Access)

Could any one help me with the VB expression to achieve this?




------------------
My best advice?
RTFM.
What?
Read The F***ing Manual.