sql = "select stock.* from stock where " If TextBox1.Text <> "" Then sql = sql & "article= '" & TextBox1.Text & "' and " sql sql & " SELECT article, dentrer from stock WHERE dentrer (SELECT MAX(dentrer) FROM stock)" T1.Text = dtt.Rows(rownum).Item("article") T2.Text = dtt.Rows(rownum).Item("dentrer")
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSELECT article, dentrer from stock WHERE dentrer = (SELECT MAX(dentrer) FROM stock WHERE ...) AND ...