Combine user input and wildcard

[Philip Gabe]

I'd like to have a query that uses a selection criteria that combines a value
entered by the user and a wildcard. In particular, I have records that have
values such as 13050, 13100, 13200, 15100, 15200, 16100, 16500, etc. in one
field. I'd like a user to be able to enter just the first two digits and
have the query return all records that match those two digits. By using the
criteria of [Div #]+"050" I can get the query to work, but I can't figure out
how to use wildcard characters in place on the value in quotes.

 

[Jeff Boyce]

Philip

Take a look at Access HELP on parameter queries.

In the Selection Criterion "cell" under your field, put something like:
Like [Enter first two digits] & *

Regards

Jeff Boyce
Microsoft Office/Access MVP