Hi, I'm stumped and need help. I'm working on a complex Access report, with several subreports many levels deep. The trouble started when adding a new subreport to the main one.
In the (subreport) print preview, it shows all fields same as the design view, just as it should. When the subreport is added to the main one, the layout changes. It shows the first field, no problem, but only one of the others, and not where it should be.
It just occurred to me (while writing this) that the subreport query is comprised of subquerys, and these are the fields that don't layout right. I'll try saving the results of the query into a table, then use that in the subreport, and hope this resolves things.
I thought I was getting the hang of Access, now I have my doubts.
False alarm. My bad! I was looking at one thing, thinking I was seeing something else.
Urgent,Plz help me .......need to calculate the total of a field in subreport.