Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query providing duplicate data when combined
There is an ID field in the first table as well - looks like I forgot to type that one in there.- bshaw03
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Query providing duplicate data when combined
Ok, because I'm at work and the site to upload is blocked I'll try it this way: (all ID are autoset by Access and noted as the primary key for their respective tables) TblContract Cont_# DO_# Program_Title Award_Date DO_PoP_Start_Date...- bshaw03
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Query providing duplicate data when combined
Hello, I am fairly new to access but thought I was getting the hang of it until I ran into this roadblock. I have 4 tables that I'm attempting to pull data from and put into a query. When I create the queries on an individual basis, they work fine (1 query for 3 of the tables). However, when...- bshaw03
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
