Share via

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

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
859 questions
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  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