Recent content by jburger9
-
J
Data missing from 2 table query
Just tried it now and did the same :( Its about 2/3 of the column thats blank, the rest are OK. Its not as if there were missing records sporadically, there is a clear divide.....Its very strange.- jburger9
- Post #5
- Forum: SQL Server
-
J
Data missing from 2 table query
Really appreciate the reply. I tried this however still didnt work unfortunately. There are no primary keys as the tables are ODBC links and I have checked and the missing data is definitely in the tables. Thanks- jburger9
- Post #3
- Forum: SQL Server
-
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...