Search results
-
J
Data missing from 2 table query
Hi all, I am attempting to run a query based on 2 tables. In the query there are 3 fields from table 1 and 2 fields from table 2. The common field in both is Change.ID The query is working however there is about 70% of the data missing from the 2 fields in table 2 I have checked and...- jburger9
- Thread
- Replies: 5
- Forum: SQL Server
-
J
Conflict between Order By and Group By/Distinct
Hi all, I am relatively new to Access, and have only made a few databases so far. The one I am stuck on currently involves 2 tables via an ODBC link. There is a unique field in both tables (ID) however it is giving me an error that the field is found in both tables. When looking at the...