> When you enter your search criteria it is not necessary to enter the > single quotes, front and back, they are added by application - but > entering them will not cause a problem either. > > Drew That was exactly what I was looking for. It seems the query does exactly what I was thinking of. I must remember only to modify the query accordingly and then remember to place my arguments in between % signs.
>Now some caveats. You mentioned here: >Now you run the query a third time and enter %depression, >hypertension% - it will return only 1 record. It missed a record. I >will leave it to you to see why that is...Hint - you must be very >careful when you enter your data. This is to say that anything that doesn't totally match the criteria, meaning, unless the record has 'depression AND hypertension' the record would not be returned so a record only having depression would be missed. This is acceptable since I would only be working on gathering all medications for one disease process at a time. Presumably, I'd only be entering one argument (disease) at a time. In any case thank you very much for your help. I had an idea it would have something to do with the "Like" string but was unclear on how to implement it. -- Patience yields far greater results than brute force or rage ever could so relax......it's just life !!! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
