I've been away for awhile.
I have a Report which will have several SubReports. The primary SubReport is where I'm struggling. It is based on a CrossTab query. When I Open the Report it keeps recalculating and Recalculating and..... you get the idea.....
To see what I mean I've attached a stripped down db.
To see what I mean and to open the Report.... Open frm_Testing
. Then in the "Select ShiftID" combobox select Shift Number 432.
Then click the Command Button to Open the Report.... You'll see what I mean......
I suspect that it has to do with the way I designed either the Crosstab query (which is cTabqry_LVLDetailEODSinceL
hMach) OR it's one of the Queries that that CrossTab is based upon.....
I've opened and run each of the Queries and they all run fine but the Opening of the Report keeps calculating.... I'm stumped (the query doesn't keep calculating like that when I Run it??????????)
THANKING you Experts in Advance for any suggestions!!!