K
kealaz
I am using [Enter Drawing Number:] in a query so that when the query is run,
the user is asked to enter a drawing number. Right now, if the user is
looking for 12345-A and only enters the number 12345, there is no results
given because Access does not find a match. I would like to make it so that
12345-A comes up if just the number is entered.
I have tried
[Enter Drawing Number:]*
and
[Enter Drawing Number:]"*"
both of which gives me a syntax error.
I have also tried
[Enter Drawing Number:] + "*"
which does not give me a syntax error, but when I run the query, I get no
results, which means it's not working.
Can anyone help me out here?
Thanks a bunch!!!
the user is asked to enter a drawing number. Right now, if the user is
looking for 12345-A and only enters the number 12345, there is no results
given because Access does not find a match. I would like to make it so that
12345-A comes up if just the number is entered.
I have tried
[Enter Drawing Number:]*
and
[Enter Drawing Number:]"*"
both of which gives me a syntax error.
I have also tried
[Enter Drawing Number:] + "*"
which does not give me a syntax error, but when I run the query, I get no
results, which means it's not working.
Can anyone help me out here?
Thanks a bunch!!!