I've just got Crystal Reports 8, and every time I install it, it says that the example apps have been installed, but they aren't there. Therefore I'm fumbling around trying to make the simplest of things work before I carry onto more complex things.

Anyway I use the following query in Access and it gives me the results I expect, but when I use it from VB with Crystal I get the results twice.

Code:
  strSQL = "SELECT Employees.*, Employee_Change_History.* " & _
           "FROM Employees, Employee_Change_History " & _
           "WHERE Employee_Change_History.Employee_Id = '" & txtSearchByID.Tag & "'" & _
           "AND Employees.Employee_Id = Employee_Change_History.Employee_Id"
Anybody know why??