Multiple table on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a report that will pull it's information from one
querry. I would like to know if it is possible to have more than one 'table
' of information on the same report. The first portion will have the dept
and budget reforecast for each month of the year. The next portion I would
like to have the same thing but with actual numbers and finally the last
would be the variance. I want each mimic the look of a table, so I would
like it to appear as if there are three tables. I hope I have supplied
enough info so you can tell me if this can be done.

Thanks! I appreciate any help.
 
Though I am not as good as the MVP's who help here, there are several options
that I have used. The easiest is to create 3 reports each containing 1 of the
3 portions you want. Then create a 4th report which is blank. Place the other
3 reports onto the blank one as a SubReport. (You can add a SubReport using
the SubReports tool in the Toolbox). A wizard will open and guide you thru
the setup.
 
Thank you very much. I have never created a report with subreports, but here
goes nothing.
 
Back
Top