Variables in SQL

[Tronsliver]

I'm new to this. Here is my question. Can I use a variable in an SQL statement? Please look at my code below. I'm trying to insert "y". Can this be done?

Public Sub AccessionChart(x As Variant)
Dim y As Variant
y = x
Me.MyChart.RowSource = "SELECT Null, y FROM [AccessionsQry]"
Me!MyChart.charttitle.Text = "Accessions"
Me.MyChart.Refresh
End Sub

 

[tomschafer]

Try this...

Public Sub AccessionChart(x As Variant)

Me.MyChart.RowSource = "SELECT Null, " & x & " FROM [AccessionsQry]"
Me!MyChart.charttitle.Text = "Accessions"
Me.MyChart.Refresh
End Sub

 

[Tronsliver]

Thank you very much