Data Search Engine

G

Grant Kieffer

For my company I have purchase order numbers that compose
of 3 letters and than the date. I need to be able to
search just by the three letters or part of the order
number so that it displays mutiple results.

Any suggestions will be appreciated
 
M

Michel Walsh

Hi,


PO Like "abc*'

or

PO Like "?b[cd]*"


See help file about all the possible syntax for the operator Like. If you use ADO, you may need to
use % and _ as wildcards.


Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching for a digit or letter only 3
Numbers & text 8
Append Invoice 22
query criteria Not Like ... <> 2
Searching for Missing Data 1
Access Query for keeping a total hours remaining. 0
Using a query to search for data 1
How to query a Dataset to Return Records that contain "a thing" 5

Top