Query with variable

  • Thread starter Thread starter masremi
  • Start date Start date
M

masremi

Hello !

I am a beginner with access and I want to add a variable in a query for a
form :

The query is :
SQL = "SELECT TblArticoliFigli.[ArticoloFiglio], TblArticoliFigli.[Articolo]
FROM TblArticoliFigli WHERE (((TblArticoliFigli.[Articolo])='1068871'));"

That is works correctly ! I replace '1068871' by the variable IdArticolo

SQL = "SELECT TblArticoliFigli.[ArticoloFiglio], TblArticoliFigli.[Articolo]
FROM TblArticoliFigli WHERE (((TblArticoliFigli.[Articolo])=' & IdArticolo &
'));"

And it os not working ... what is the correct code to use a variable ???

Thanks for your help.
 
You're very close, just need a " character after the & character after
IdArticolo:

SQL = "SELECT TblArticoliFigli.[ArticoloFiglio], TblArticoliFigli.[Articolo]
FROM TblArticoliFigli WHERE (((TblArticoliFigli.[Articolo])=' & IdArticolo &
"'));"
 
Ken said:
You're very close, just need a " character after the & character after
IdArticolo:
Click to expand...

There should also be a " immediately after the first '
SQL = "SELECT TblArticoliFigli.[ArticoloFiglio], TblArticoliFigli.[Articolo]
FROM TblArticoliFigli WHERE (((TblArticoliFigli.[Articolo])=' & IdArticolo &
"'));"
Click to expand...

I'd try a more concise style --- it helps me keep track of quotes.

SQL = "SELECT ArticoloFiglio, Articolo " & _
"FROM TblArticoliFigli WHERE Articolo='" & IdArticolo & "';"
 
Thank you !

The second solution works perfectly ;-)

I was becoming crazy with the '"'"'"'" and the first solution did not work !

Thank you for your help !

Hans Up said:
Ken said:
You're very close, just need a " character after the & character after
IdArticolo:
Click to expand...

There should also be a " immediately after the first '
SQL = "SELECT TblArticoliFigli.[ArticoloFiglio], TblArticoliFigli.[Articolo]
FROM TblArticoliFigli WHERE (((TblArticoliFigli.[Articolo])=' & IdArticolo &
"'));"
Click to expand...

I'd try a more concise style --- it helps me keep track of quotes.

SQL = "SELECT ArticoloFiglio, Articolo " & _
"FROM TblArticoliFigli WHERE Articolo='" & IdArticolo & "';"
Click to expand...
 
Back
Top