Brian Not sure if this is what you're after, but you could try it:
1 - in one single object for each different value in column A, add the text you want in column B. 2 - SQL select where Column B <> "", grouped by column B, into query 1 3 - update column B in original table using data from query 1, where Table.column A = query1.column A This means you don't have to do individual queries for each listing in column A. Does this make sense? I hope so. I do it often. Caroline --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3857
