Hi:

I have this code in SQL,and I just want extract the 3 big's values from my database(ACcess) working in DAO....but the code extract all the values >='90' and not the only 3 big values >='90'

something wrong with code?


VB Code:
  1. sql1 = _
  2.      "select top 3 pontosind1 as Totais, classifind1 as Classifind, seccao1 as Secção, classe1 as Classe, designacao1 as Designação, nomesocio as Expositor, anilha1 as Anilha, gaiolaind1 as Gaiola, Sexo1 as Sexo" & _
  3.      " from exposicao " & _
  4.      " WHERE pontosind1 >= '90' & _
  5.      "and (pontoseq1 = '' or pontoseq1 is null) " & _
  6.      " UNION ALL" & _
  7.      " select pontosind2, classifind2, seccao2, classe2, designacao2, nomesocio, anilha2, gaiolaind2, sexo2" & _
  8.      " from exposicao " & _
  9.      " WHERE pontosind2 >= '90' & _
  10.      "and (pontoseq1 = '' or pontoseq1 is null) " & _
  11.      " UNION ALL" & _
  12.      " select pontosind3, classifind3, seccao3, classe3, designacao3, nomesocio, anilha3, gaiolaind3, sexo3" & _
  13.      " from exposicao " & _
  14.      " WHERE pontosind3 >= '90' & _
  15.      "and (pontoseq1 = '' or pontoseq1 is null) " & _
  16.      " UNION ALL" & _
  17.      " select pontosind4, classifind4, seccao4, classe4, designacao4, nomesocio, anilha4, gaiolaind4, sexo4" & _
  18.      " from exposicao " & _
  19.      " WHERE pontosind4 >= '90' & _
  20.      "and (pontoseq1 = '' or pontoseq1 is null) " & _
  21.      " ORDER BY classe desc,Totais desc "

thanks