Totals Report

[Amac]

I would like to create a summary report based on a "Type" field in my
table. I would like to create the following report:

Type 1 Total Balance Type 4 Total
Balance
Type 2 Total Balance Type 5 Total
Balance
Type 3 Total Balance Type 6 Total
Balance
----------------------------------------------------------------------------
Grand Total
Grand Total
I don't want the details, just the totals, but I don't know how to do
it in this format. I can break it by type and get the totals, but not
in this format.

Can someone help me?

Thanks
Andy

[MGFoster]

Amac wrote:

I would like to create a summary report based on a "Type" field in my
table. I would like to create the following report:

Type 1 Total Balance Type 4 Total
Balance
Type 2 Total Balance Type 5 Total
Balance
Type 3 Total Balance Type 6 Total
Balance
----------------------------------------------------------------------------
Grand Total
Grand Total
I don't want the details, just the totals, but I don't know how to do
it in this format. I can break it by type and get the totals, but not
in this format.

See this site for explanation of how to put a report in columns:

http://support.microsoft.com/kb/q90870/

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

[Amac]

Thanks


MGFoster wrote:

Amac wrote:

I would like to create a summary report based on a "Type" field in my
table. I would like to create the following report:

Type 1 Total Balance Type 4 Total
Balance
Type 2 Total Balance Type 5 Total
Balance
Type 3 Total Balance Type 6 Total
Balance
----------------------------------------------------------------------------
Grand Total
Grand Total
I don't want the details, just the totals, but I don't know how to do
it in this format. I can break it by type and get the totals, but not
in this format.

See this site for explanation of how to put a report in columns:

http://support.microsoft.com/kb/q90870/

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)