Query with variable

[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.

 

[Ken Snell [MVP]]

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 &
"'));"

 

[Hans Up]

You're very close, just need a " character after the & character after
IdArticolo:

There should also be a " immediately after the first '

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

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

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

 

[masremi]

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 !

You're very close, just need a " character after the & character after
IdArticolo:

There should also be a " immediately after the first '

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

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

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

 

[Ken Snell [MVP]]

There should also be a " immediately after the first '

Good catch.. my old eyes.... < s >