Create separate columns or blocks in an access report

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

Guest

I have a report I am trying to create. I would like to set up multiple
columns or blocks within the details section. At first glance it does not
seem like Access is set up for this.

I have 3 data sets that need to go in the "detail" section. One will run
down the left side of the page. I would like to put the other two sections
(or blocks) of information on the right side of the "detail" section and
stack them.

Is this possible in Access? If not, is there an add-on program that can
handle this?

Thanks,

Ryan
 
Hi,
you can set up columns in reports by either going to page setup when in
design view and select the column tab. You can then specify how many columns
you want, or use a crosstab query as the source of your report.
HTH
Good luck
 
If you are using one record source for the report (required), then
freakazeud's suggestion is correct; however, you said 3 data sets. Are you
saying you are trying to use multiple tables or queries in the same report?
If so, ain't gonna happen. If you are using 3 different tables or queries,
then you will have to create a sub report each for 2 of them.
 
The sub reports worked perfectly. That is exactly what I wanted. I was able
to block detail section of the report and create just what I wanted.

Thank you.
 
Back
Top