Access (Version 2103) Wildcard Behaviour

Phil S 261 Reputation points
2021-05-05T09:38:33.37+00:00

Hi all

Right newbie question here...

I have a field in a table which holds drawing numbers of the form 010-04-019-00.
The data-type due to the hyphens is short text.
I have a query with criteria =[Enter Drawing Number].
If I input the entire number when running the query, the record is returned.
If I input part of the number and * I get nothing.

Conversely, change the criteria to Like[Enter Drawing Number].
Input the known drawing number and nothing is found.
Input an asterisk and all results are shown.

An I missing something or using the wrong wildcard perhaps??

Thanks

Phil

Microsoft 365 and Office | Access | Development
0 comments No comments
{count} votes

Accepted answer
  1. DBG 2,456 Reputation points Volunteer Moderator
    2021-05-05T15:10:12.147+00:00

    Hi. What do you get if you use this criteria?

    Like "*" & [Enter Drawing Number] & "*"
    
    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Phil S 261 Reputation points
    2021-05-05T17:22:05.113+00:00

    Thanks DBGuy

    That works, but I'm not sure why manual entry of the * character doesn't.

    Phil


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.