Stevie
Jun 12th, 2000, 12:08 AM
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.
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??
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.
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??