Access Query filter criteria self duplicating

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Coolbreeze
    New Member
    • Feb 2013
    • 1

    Access Query filter criteria self duplicating

    Hi,
    I have specified form textbox data as query filter criteria,and since then, every time I run the query, the criteria are self duplicating on random lines below the original. Also, there seems to be additional coulmns being created on the right end of the query... I'm submitting a screen shot for clarity. Any ideas?
    [IMGnothumb]http://i.imgur.com/f3Strmk.jpg[/IMGnothumb]
    Last edited by zmbd; Feb 8 '13, 10:09 PM. Reason: [z{made image inline for those that can see it}]
  • zmbd
    Recognized Expert Moderator Expert
    • Mar 2012
    • 5501

    #2
    Coolbreeze:
    Please be aware that most of us can not see your attached image because our company IT tends to block such sites.

    Therefore, it is always much better to put your information within the post, not rely on a picture unless specifically asked by one of us.
    IN this case, post the SQL too.

    The other issue with your image is that you've redacted several of your fields... we can't properly evaluate your query without that information.
    Last edited by zmbd; Feb 8 '13, 10:11 PM.

    Comment

    • zmbd
      Recognized Expert Moderator Expert
      • Mar 2012
      • 5501

      #3
      When you say "Run the query"
      Do mean from the UI or from VBA or Macro?

      Comment

      • NeoPa
        Recognized Expert Moderator MVP
        • Oct 2006
        • 32653

        #4
        Access often reinterprets your SQL if it feels it can/needs to.

        Before we can comment more specifically we would need to see (in SQL form) what it was you originally entered and what was saved by Access.

        Comment

        Working...