So what if you break it down into smaller steps? Edit all from colorlist Edit all from colorlist where colornum contains '123' Edit all from colorlist where colornum contains '456' And my favorite mistake, spelling from as form when I type to fast. Jim
>>> "Dick Fey" <[EMAIL PROTECTED]> 9/3/2008 9:45 AM >>> Some years back I had code in one of my apps to do a specific search. Seemed no-one was using it, so I deleted it. Now they want it back, and I can't figure out how I did it in the first place. Seems like a simple problem. Need to find a product in the database where more than one color number matches a product. Each color may exist in many products, but I want to see the product(s) that have both colors. ie: Edit all from colorlist where colornum contains '123' and colornum contains '456' Anything I try gives me a syntax error, or a no rows exist error. I know the rows are there, so its a syntax issue. Suggestions appreciated. Dick Fey Carpet Broker Inc.
