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

How to Query for Fields with the same values

P: 58
I would like to write a query that would return all records within a single table "Imported Transactions" where two fields are duplicated. For example I am looking at the 'Date' & 'TransNum' fields. These records are imported from another location. I am trying to check if any records were imported more than once. So if both the Date and TransNum fields are the same in two or more records I want the query to return the data.

If any of this is not clear please let me know.

Please help!

Thank you in advance.
May 23 '07 #1
Share this Question
Share on Google+
2 Replies

P: 58
I just discovered the Find Duplicate Records Query templates! I should have known. Thanks anyway.
May 23 '07 #2

NeoPa
Expert Mod 15k+
P: 31,770
That's the beauty of a place like this Burton.
You only have to post the question here - the answer can come from anywhere once it's posted though :D
May 24 '07 #3

Post your reply

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