John Clark
John.Clark at niagaracounty.com
Fri Jul 8 08:20:17 CDT 2005
This is probably beyond simple, but I really don't use it very often, and I just ran into a problem. I am trying to whip up a table of approximately 20,000 drugs. Many of the drug listings are actually the same drug, but with different strengths. For example: Field5 ID Field1 Field2 Field3 Field4 Field6 Field7 ABILIFY 1 MG/ML SOLUTION 13 BEX 59148-0012-15 2.31031 0 OTSUKA AMERICA ABILIFY 10 MG TABLET 14 BEX 59148-0008-13 10.04479 0 OTSUKA AMERICA ABILIFY 15 MG TABLET 15 BEX 59148-0009-13 10.04479 0 OTSUKA AMERICA ABILIFY 20 MG TABLET 16 BEX 59148-0010-13 14.20458 0 OTSUKA AMERICA ABILIFY 30 MG TABLET 17 BEX 59148-0011-13 14.20458 0 OTSUKA AMERICA ABILIFY 5 MG TABLET 18 BEX 59148-0007-13 10.04479 0 OTSUKA AMERICA I want to build a query that let you type in Tylenol and get to that drug, or even "T" and get to that point of the list, where the "t"s are located. I tried using a "Like" statement in the query, but it didn't work. How is this done? Thank you! John W Clark