Wondering if there is an upper limit on how many sub reports can be put in a report? I’ve got a report that represents locations at a harbour. Think of this like a parking/berthage map. There are 43 locations in total, so I have 43 sub reports that are based on an individual query for each location. Unfortunately, the most sub reports I can get on to the report is 37. After that the program gives the error that there is not enough memory.
I tried to solve this problem by putting more that one query in each sub report but this does not seem possible. If it is possible to put more than one query in each sub report that would be great to get some direction as to how this is accomplished as I could not figure this out.
The only solution I could come up with is putting six locations on a second report. So I have one repor
This gets the job done, but the ideal would be to see all the information on one report/page. The information in the sub reports can change daily so the main report gets run often, sometimes more than once each day as things change.
Access version is 2309 -Microsoft 365 Computer 8GB 64 bit Windows 10 Pro
This is the query for location E1D1 (35)
SELECT BOAT.BOAT_NAME, LOCATION.Float, LOCATION.DOCK,
LOCATION.ORIENTATION, BERTHAGE.BERTH_WEEK, BERTHAGE.BERTH_YEAR
FROM LOCATION RIGHT JOIN (BOAT RIGHT JOIN BERTHAGE ON BOAT.BOAT_ID =
BERTHAGE.BOAT) ON LOCATION.LOC_ID = BERTHAGE.LOCATION
WHERE (((LOCATION.Float)="E1") AND ((LOCATION.DOCK)="D1") AND
((LOCATION.ORIENTATION)="North") AND
((BERTHAGE.BERTH_WEEK)=DatePart("ww",Now(),2,2)) AND
((BERTHAGE.BERTH_YEAR)=Year(Now())));