Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Posts
    21

    Unanswered: Another query question

    I am wanting to find the Project Name where the Job ID equals a known value and I want to assign the matching Project Name to a variable. Can anyone point me to an example?

    ie:
    dim MyProjectName as string
    MyJobID="BL12345"
    MyProjectName = SELECT * FROM Orders WHERE JobID=MyJobID;

    Is this possible or will I have to open a recordset and find the first record that matches my criteria?

    In the Orders table, the JobID field is unique, so the criteria should only match one record.

    flynn

  2. #2
    Join Date
    May 2002
    Location
    Atlanta, GA
    Posts
    117
    Try "SELECT * FROM Order WHERE(Jobid = " & "'" & MyJobID & "'" & ")"

Posting Permissions

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