Yet another datareport problem

[faroukmuhammad]

Whenever I command my datareport to show, my computer halts. Their are other four report that work well. Then there is the only one that is pulling on my legs. Can any one tell me what the problem might be?

[debasisdas]

Does that involves a complex query or fetching too many records ?

[faroukmuhammad]

Well, this is my qeury;

query = "SELECT * FROM tblpersonal INNER JOIN tblhistory ON tblpersonal.staff_id = tblhistory.staff_id WHERE (((tblpersonal.doc) <= #" + Dtgen + "#) AND ((tblhistory.latest)=1)AND ((tblpersonal.active) = 'Yes'))ORDER BY tblpersonal.fname"

and the resulting table has 39 fields!!! :icon_rolleyes:
is that too much? if yes please give me anoter option.

The Report suppose to print staff's personal information and staff's latest carrier histoy.

[debasisdas]

Are you using all the 39 fields in the report ?

[faroukmuhammad]

No, o.k: i should select only the one's that i am going to use, right. :$.

[debasisdas]

Yes, and if still the problem is there try to remove the order by temporarily.

[faroukmuhammad]

I tried deleting the source code and writing it again, I solved the problem...