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