Its Friday afternoon & I can't seem to get this query right. I could sure use a little help.
I have a tables of wells, this wells are located in areas (fldcode) and are active or abandoned (based on whether or not [abd date] has a date entered). I want to generate a list of the areas (fldcode) where all the wells are abandoned; or in other words, none of the [abd date] have a null value. I have tried all sorts of variations of this, what am I doing wrong? SELECT DISTINCT well.FLDCODE FROM well WHERE (((well.FLDCODE)<> any (select FLDCODE from well where isnull([ABD date]) ))); Thanks all. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15443
