hi, I have an access 2003 program where the BE resides on the server and the FE on the clients PC. One of my reports had 2 sub-reports and it really loads so slow compare to the reports I made with only one sub-report all on the same data's. So how can I speed it up. I'll give you the screen-shots to understand it easily.
Report w/ 2 sub-reports: report.png
Report w/ only one sub-reports: report1.png