By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,842 Members | 2,347 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,842 IT Pros & Developers. It's quick & easy.

Access Query filter criteria self duplicating

P: 1
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?

Feb 8 '13 #1
Share this Question
Share on Google+
3 Replies


zmbd
Expert Mod 5K+
P: 5,331
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.
Feb 8 '13 #2

zmbd
Expert Mod 5K+
P: 5,331
When you say "Run the query"
Do mean from the UI or from VBA or Macro?
Feb 8 '13 #3

NeoPa
Expert Mod 15k+
P: 31,306
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.
Feb 9 '13 #4

Post your reply

Sign in to post your reply or Sign up for a free account.