Data Search Engine

  • Thread starter Thread starter Grant Kieffer
  • Start date Start date
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
 
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
 
Back
Top