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

New User to Access 2007

P: 2
I am creating a database for my boss and I am a new user to Access, so pretty much I am bumbling through slowly. I created two tables with similar info for two sep semesters. I created a query for each of these tables and wanted to compare the info of each one. When I created a report with the two queries, it duplicated records that can not be gotten rid of when I click hide duplicates. When creating a query of the two original queries, the same thing happens, duplication of records. Need some help on resolving this problem please.
Nov 4 '08 #1
Share this Question
Share on Google+
2 Replies

P: 68

This sounds like you don't have any relationship set up between the tables or within the queries, (or if you have, that it needs looking at) and consequently the third query is returning every record in table 2 for each record in table 1, and vice versa. There's a good tutorial on relationships on this site, worth looking at that first.

Nov 12 '08 #2

P: 2
I have a forced referential integrity set up in the junction table, does that make a difference? I am new at all of this and I feel like this is a constant fight.
Nov 18 '08 #3

Post your reply

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