Creating a table-like looking report

[MichelleM via AccessMonster.com]

Here is what I would like to do:

The rows would be the names of agents in the call center. The 2 columns
would be # of outbound calls and # of inbound calls for a date range and then
the totals of inbound and outbounds calls for the group at the bottom.

I have the query created that gives me the correct information, now I just
need to know how to set up the report in order to do this.

 

[Larry Linson]

In the Detail Section of the Report, create 3 Text Boxes to display the
values from the Query you are using as Record Source for the Report. The
text boxes should touch each other where they abut at the end. Set the
BorderStyle to Solid (it normally defaults to Transparent), and the
BorderWidth to a size that fits your needs (it normally defaults to
Hairline). Size the Text Boxes to contain the Font Size you choose, then
move them to touch the top of the Detail Section, and move the bottom of the
Detail Section up to touch the bottom of the Text Boxes.

Create similar Text Boxes in the Report Footer, and size the Footer as
described above.
In the Report Header or Page Header, as you prefer, create Text Boxes to
contain the Column Names.

Larry Linson
Microsoft Office Access MVP