Access 2002, Crystal Reports 8.5
How can you make a field in a query an indexed field? I have a Crystal report in which I would like to include data from two queries, I have included the indexed table that they relate too, to try and link them, but it complains they are not indexed fields.
The two Queries are Number Of Patients (NumPatients, PracticeID) and Seen More Than Once(Total,PracticeID). Both tables hold an integer value for the number of patients per practice for that table. They also both link back to an indexed table Consults.
Does anyone have any ideas? thanks
How can you make a field in a query an indexed field? I have a Crystal report in which I would like to include data from two queries, I have included the indexed table that they relate too, to try and link them, but it complains they are not indexed fields.
The two Queries are Number Of Patients (NumPatients, PracticeID) and Seen More Than Once(Total,PracticeID). Both tables hold an integer value for the number of patients per practice for that table. They also both link back to an indexed table Consults.
Does anyone have any ideas? thanks
