Totaling different field types

[Ryker]

In table A I have a field called Color.

I have a color report that groups the colors and prints the total.
One section will list and total all the records that have red in the
color field, one section will list and total all the records that have
blue in the color field, ect. I need on the grand total page to print
a summary of the previous counts.

Total Red ____
Total Blue _____
Total Yellow ____

I use record count in the grouping and it is working ok. I just can't
get the totals to print on the grand total page. How do I do this?

[Marshall Barton]

Ryker wrote:

>In table A I have a field called Color.

I have a color report that groups the colors and prints the total.
One section will list and total all the records that have red in the
color field, one section will list and total all the records that have
blue in the color field, ect. I need on the grand total page to print
a summary of the previous counts.

Total Red ____
Total Blue _____
Total Yellow ____

I use record count in the grouping and it is working ok. I just can't
get the totals to print on the grand total page. How do I do this?

Quick and dirty:
=Count(IIf(Color="Red", 1, Null))
But then, what will you do when you have a new color?

Better to create a Totals type query that calculates all the
totals:
SELECT Color, Count(*) As ColorCount
FROM table
GROUP BY Color

Then create a new report to display the query's data and use
this report as a subreport.

--
Marsh

[Ryker]

On Feb 7, 2:06 pm, Marshall Barton <[e-mail]:

Ryker wrote:

In table A I have a field called Color.

I have a color report that groups the colors and prints the total.
One section will list and total all the records that have red in the
color field, one section will list and total all the records that have
blue in the color field, ect. I need on the grand total page to print
a summary of the previous counts.

Total Red ____
Total Blue _____
Total Yellow ____

I use record count in the grouping and it is working ok. I just can't
get the totals to print on the grand total page. How do I do this?

Quick and dirty:
=Count(IIf(Color="Red", 1, Null))
But then, what will you do when you have a new color?

Better to create a Totals type query that calculates all the
totals:
SELECT Color, Count(*) As ColorCount
FROM table
GROUP BY Color

Then create a new report to display the query's data and use
this report as a subreport.

--
Marsh

That worked great. Thanks for your help!