Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    26

    Unanswered: Reference Query Directly

    Is it possible to reference the value in a query direct.

    Say my query name is qryTest and it consists of Name, Age, Weight.

    I would like the following to happen.

    Dim Temp as String
    Temp = [qryTest][Name]

    The query will also be filtered so that only 1 name, age and weight woudl appear if that makes a difference. I have fooled around with this with no luck, any help would be appreciated.

    Thanks.
    Life's a bowl of punch, go ahead and spike it.

  2. #2
    Join Date
    Jul 2003
    Posts
    26
    I figured out a way to do indirectly, problem solved.
    Life's a bowl of punch, go ahead and spike it.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    select Name from qryTest

    Logically, stored queries (and even subqueries) are handled no differently from tables in SQL.

Posting Permissions

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