Results 1 to 2 of 2
  1. #1
    razkowski is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2012
    Posts
    16

    Use an operator in a parameter query

    Hello-



    I'm trying to determine how to use the not equal to operator "<>" in a parameter query. IE...when the parameter value dialog box pops up, I want to tell the query to exclude certain entries by using "<>". Unfortunately, it's not working for me. Where am I going wrong?

    Thanks

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I don't think operators can be dynamic. The input via popup is just a string of characters, not a valid operator.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. AND Operator in the Query
    By drunkenneo in forum Queries
    Replies: 1
    Last Post: 06-09-2014, 11:27 PM
  2. Mathematical comparison operator in query
    By kazaccess in forum Queries
    Replies: 13
    Last Post: 07-22-2013, 01:25 AM
  3. DateDiff Missing Operator? Long Query
    By ewassmer in forum Queries
    Replies: 1
    Last Post: 08-25-2011, 10:46 AM
  4. like operator in access query
    By mit in forum Access
    Replies: 3
    Last Post: 06-15-2011, 03:21 PM
  5. Pass list as parameter to in operator
    By bliever in forum Queries
    Replies: 5
    Last Post: 11-11-2009, 03:15 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums