Help with Data Report Query

[[email protected]]

I have write a query which works very fine in access but when i am trying to run it through Data Environment it through a runtime error:

Run-time error '-2147467259 (80004005)':
Relate, Compute By, and Sort operations cannot be performed on column(s) whose defined size is unknown or too large.

Here is the Query;

SELECT PatientTbl.PatientId, PatientTbl.PatientName, PatientTbl.ADDRESS, PatientTbl.AGE, PatientTbl.Sex, TestGroupMasterTbl.GroupNo, TestMasterTbl.LabNo, TestMasterTbl.TestDate, TestMasterTbl.PatientType, TestMasterTbl.BedNo, TestMasterTbl.TokenAdNo, TestMasterTbl.DoctorId, TestMasterTbl.DepartmentId, TestMasterTbl.TimeOfCollection, TestMasterTbl.TimeOfTest, TestMasterTbl.ConsultantId, ConsultantTbl.Name, ConsultantTbl.Degree, TestListTbl.TestNo, TestListTbl.Test, TestListTbl.NormalRange, TestDetailGroupTbl.Specimen, TestDetailTbl.Value, TestGroupMasterTbl.CategoryNo, TestGroupDetailTbl.SubCategoryNo
FROM TestListTbl INNER JOIN ((TestGroupMasterTbl INNER JOIN (PatientTbl INNER JOIN ((ConsultantTbl INNER JOIN TestMasterTbl ON ConsultantTbl.ConsultantId = TestMasterTbl.ConsultantId) INNER JOIN (TestDetailTbl INNER JOIN TestDetailGroupTbl ON TestDetailTbl.GroupNo = TestDetailGroupTbl.GroupNo) ON (TestMasterTbl.LabNo = TestDetailTbl.LabNo) AND (TestMasterTbl.LabNo = TestDetailGroupTbl.LabNo)) ON PatientTbl.PatientId = TestMasterTbl.PatientId) ON TestGroupMasterTbl.GroupNo = TestDetailGroupTbl.GroupNo) INNER JOIN TestGroupDetailTbl ON TestGroupMasterTbl.GroupNo = TestGroupDetailTbl.GroupNo) ON (TestListTbl.TestNo = TestGroupDetailTbl.TestNo) AND (TestListTbl.TestNo = TestDetailTbl.TestNo)
WHERE (((TestMasterTbl.LabNo)=[?]));


Please help;
Wasim Zafar

[sapator]

Maybe a problem in
TestMasterTbl.LabNo)=[?]))
with the "?" variable.
I had some problem when i wrote queries for SQL and Access in a dataset.
Now it's crystal reports, so i cannot be sure.

[mabbas110]

Please if u can explain the where clause.