- Local time
- Today, 12:49
- Joined
- Feb 19, 2013
- Messages
- 17,626
can't really help without seeing the data/queries - and not clear what your final report is supposed to look like with 6 subreports.
Your sql would appear to not have enough joins
Would also help if you aliased your queries and not use spaces in table names - makes the sql much easier to read. For example
SELECT * FROM 2024_ORG_ST_Summary_ABCD AS M INNER JOIN Sub_Report_qrySource1 AS R1 ON M.StateName = R1.StateName AND M.TstNum = R1.TstNum
Your sql would appear to not have enough joins
Would also help if you aliased your queries and not use spaces in table names - makes the sql much easier to read. For example
SELECT * FROM 2024_ORG_ST_Summary_ABCD AS M INNER JOIN Sub_Report_qrySource1 AS R1 ON M.StateName = R1.StateName AND M.TstNum = R1.TstNum
