Tom/Modridirkac-

Thanks!  This works.

Kevin

"modridirkac"  wrote in message 
news:op.zsxntmmu34j8uf@is-jure10.mshome.net...

  SELECT * FROM "F:\app\PRV\avGroups" avGroups WHERE avGroups.grpid NOT IN
    (
      SELECT DISTINCT (selGroups.grpid)
      FROM "F:\app\PRV\selGroups"
      WHERE selGroups.MemID=101
    ) ;