Variables In VBA

[jo15765]

I am attempting to compile the syntax below to dynamically create a query using DAO. However, I keep getting an error of (on the "1")
Expected End Of Statement

What do I need to alter in this syntax so that it will compile & execute properly?

Dim va1213 As String
va1213 = "Bojava12"


qdf.SQL = "SELECT [storeRef].[empID], [storeRef]." & va1213 & " FROM storeRef WHERE ((([storeRef]." & va1213 & ") >= "1")) ORDER BY [storeRef].[empID];"

[JoeM]

The issue is that literal double-quotes often get confused with your text qualifiers.
If I want literal double-quotes, I often use Chr(34) to return them, i.e.

... & ") >= " & Chr(34) & "1" & Chr(34) & "))...

Also note that many times, SQL will accept single quotes, so you can try this to:

... & ") >= '1'))..."

[jo15765]

The issue is that literal double-quotes often get confused with your text qualifiers.
If I want literal double-quotes, I often use Chr(34) to return them, i.e.

... & ") >= " & Chr(34) & "1" & Chr(34) & "))...

Also note that many times, SQL will accept single quotes, so you can try this to:

... & ") >= '1'))..."

Hmm...I knew you could use the chr(34) in SSMS but did not realize you could do such in access. Thank you for this answer and insight!

[JoeM]

You are welcome!

[John_G]

Another point is that if val123 is a numeric, you should not have the quotes around the 1 at all.