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
 
Top