Results 1 to 2 of 2

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

  1. #1

    Thread Starter
    Lively Member elmnas's Avatar
    Join Date
    Jul 2009
    Posts
    127

    Resolved [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));")

  2. #2
    Addicted Member
    Join Date
    Jan 2009
    Posts
    183

    Re: How to make a part of this to a variable?

    Is this what you mean?

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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width