[RESOLVED] How to make a part of this to a variable?

Hello people

how do I make the number in this code to a variable? (myvar=1)
"741443"

Set rst = conn.Execute("SELECT JobbDK.JOBBNR,JoBBDK.ANM, JobbDK.JOBBESKR FROM JobbDK WHERE (((JobbDK.JOBBNR)=741443));")

Is this what you mean?

Set rst = conn.Execute("SELECT JobbDK.JOBBNR,JoBBDK.ANM, JobbDK.JOBBESKR FROM JobbDK WHERE (((JobbDK.JOBBNR)=" & CStr(myvar) & "));")