Use of Wildcard as parameter in query

Neal · February 25th, 2010, 04:41 PM

Hi,

I'm using Access 2003 and am passing a parameter in a query which is used as the record source of a report.

One of the options a user can select is 'ALL' which passes the 'Like *' code to a string which is then referred to by the parameter.

I have tried a number of different methods:

Code:

 
strPeriodParam = " Like "*""
 
strPeriodParam = Chr(32) & Chr(76) & Chr(105) & Chr(107) & Chr(101) & Chr(32) & Chr(34) & Chr(42) & Chr(34)

(The 2 examples are the same when debugging)

either is then passed to the following function:

Code:

Public Function ParameterPeriod()
    ParameterPeriod = strPeriodParam
End Function

The ParameterPeriod() is used in the specific query column. But the (report) output is NOT displaying any results. However, if I manually enter 'Like *', then it does produce results.

Any ideas Please?

Thanks in advance,

Neal · February 26th, 2010, 04:07 AM

Hi again,

I finally worked it out... it was simple (these things usually are). Firstly:

Code:

strPeriodParam = "*"

Then, within the Query, I typed the following in the Criteria row of the applicable field:

Code:

Like ParameterPeriod()

The function was left as in the original posting.

Thanks anyway,