0

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?

2
Contributors
6
Replies
7
Views
5 Years
Discussion Span
Last Post by faroukmuhammad
Featured Replies
0

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.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.