Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2013
    Posts
    2

    Unanswered: User defined filter criteria in a query

    I need help understanding a like iif expression in a query criteria in access2003:

    the true side of the expression states:
    rs_var("Select tablename.field From tablename","field")

    False side returns all values.

    The results when true are derived from a form where the user creates a list of possible values.

    Can someone please breakdown and define the functionality of this expression for me please
    rs_var() is a function I'm not familiar with. Thanks in advance.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    The expression:
    Code:
    rs_var("Select tablename.field From tablename","field")
    is not valid, nor in VBA nor in SQL.
    Have a nice day!

  3. #3
    Join Date
    Apr 2013
    Posts
    2
    This string appears in both design view and SQL view of the query. The query runs with no errors so I'm perplexed. It seemed foreign to me and searching the net provided no answers. I'm in the front end of an access db that pulls from oracle if that possibly changes things.

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Quote Originally Posted by ctaspau View Post
    ... I'm in the front end of an access db that pulls from oracle if that possibly changes things.
    Possibly if it's a pass-through query. I don't know the syntax of Oracle SQL well enough to be helpful in such a case, sorry!
    Have a nice day!

Posting Permissions

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