Wildcard for Enter Parameter Value Box?

[Mark909]

for example..

when you type in:

[Enter Item_ID)

The enter Parameter Value box appears asking for the Item ID

How would I set it up so only a wild card would need to be entered intead of
the full item name?

 

[Al Campagna]

Mark909,
Assuming this is a parameter in a query... try...
Like [Enter Item_ID] & "*"
If nothing is entered, all records are returned.
If "123" is entered, 12345, 12389, 12375 etc... are returned.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Allen Browne]

Mark, Al has probably assumed that a field named Item_ID is a required
field, and so cannot be null.

If that's not the case, be aware that any fields where Item_ID will not be
returned by this query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Mark909,
Assuming this is a parameter in a query... try...
Like [Enter Item_ID] & "*"
If nothing is entered, all records are returned.
If "123" is entered, 12345, 12389, 12375 etc... are returned.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

for example..

when you type in:

)

The enter Parameter Value box appears asking for the Item ID

How would I set it up so only a wild card would need to be entered intead
of
the full item name?