05-07-2008 01:13 AM
Have a client who wants to be able to look up the codes he usese to identify his products. These are entered in one field as they may have more than one product. I.E. If you do a a search for B11 you get all the B1* . Is it possible to sort to the second digit.
Jim D PCC SCOTLAND
05-09-2008 07:41 AM
05-10-2008 06:44 AM
Try using the % wildcard character
The percent symbol (%) will work as a wild card character to find any combination of characters within a field. For example: typing %rob into the Contact field of the Lookup or Lookup By Example dialog box will find Robert Smith, Jim Roberts and any other contact records that have the adjacent letters rob in their Contact field.
05-12-2008 01:42 AM